Virtual products selling problem

[prestaseller]

Hi, today i've finally installed prestashop, i need to sell virtual products, but here is the problem. I noticed that the max size is 8 mb. I need something bigger than that...how can i resolve?

 

Best regards.

[bellini13]

Where do you see a limit of 8mb?  I don't believe this is a limit of Prestashop, but rather your hosting environment, php settings that have likely restricted max post size to 8mb. 

[shokinro]

By default, PrestaShop set max file upload size to 100M, it is in your configuration file /config/config,inc.php/

 

if (Tools::convertBytes(ini_get('upload_max_filesize')) < Tools::convertBytes('100M')) {
    ini_set('upload_max_filesize', '100M');
}

If you see 8M limitaiton, I guess it is modified by someone or limited by your hosting server.

You can try to add php.ini file under your store root folder with following lines to override the hosting setting configuration.

 

post_max_size = 100M
upload_max_filesize = 100M

If this does not work, it mean hosting server does not allow you override, you may have to contact your service provider support for help.

 

 

 

[prestaseller]

Thank you for answers. You are totally right the problem is my web hosting. Can u suggest me a good web hosting that allow to upload more than 400 mb?

[El Patron]

really any webhosting that allows you  to change the php.ini file.  1&1 hosting is a popular vps my team likes.

[shokinro]

I am using JustHost, it is also doing good. So far I do not have any major issues.

[prestaseller]

Thanks!

[prestaseller]

I have another question. I think to resolve the upload problem thanks to ftp upload. But, how can i add my file uploaded via ftp, on my store? 

[shokinro]

the virtual product file is saved in following folder

 

StoreRoot/download/

 

but the file name is encoded, you need to find out the file name for each product from following table ps_product_download

[shokinro]

your are welcome, hope it helps

[prestaseller]

the virtual product file is saved in following folder

 

StoreRoot/download/

 

but the file name is encoded, you need to find out the file name for each product from following table ps_product_download

I see a light. Wich file name i had to copy (i added a pictures just to try, so i see the file name with .jpg in the end, and a long code near), and where i need to paste it inside prestashop?

[shokinro]

you just need rename your file to upload it and replace the file under that folder.

it must be in the same name.

[prestaseller]

Sorry i don't understand....maybe my question was wrong, i try again:

 

I upload the file via ftp

 

Next i go on front office and click on add new product

 

i select virtual product and write the product name

 

next i go on virtual product to insert the uploaded file

 

there i see add files and file name, so here where i need to paste the file name from ps_product_download ?

[bellini13]

just upload any old jpg image when you add the new virtual product.  your new jpg file will be created in the download folder.  copy the name of the newly created file, and then delete it.

 

Now upload your real jpg file, and rename it to the name you just copied.

[prestaseller]

Thank you very much! Understand all. This will work also with other extention type? Like .avi or .pdf

[bellini13]

try it and let us know

[shokinro]

yes, that should work for any files. 

[prestaseller]

Hi, maybe i do something wrong, but the method does not work

 

I tried with a video:

 

uploaded a 9mb video from prestashop product page (not ftp)

 

Then on database i copy the display_filename (examplename.mp4) and filename (something like iulhfwpru0n3vuf3p04ufè0è02923234)

 

i deleted it from database

 

then via ftp i upload a 50 mb video

 

edit the display_filename of 50 mb video on database

 

i go back to prestahop refresh the page, nothing, the filename disappears and ask me to upload a new product.

Edited July 23, 2016 by prestaseller (see edit history)

[shokinro]

You should never delete from database.

You must use your video name to replace the one under /download/ folder with exactly same of that in database.

[prestaseller]

It work fine, thanks again. But now i have a new big problem...I was tryng to customize the store menu and categories. So i was frustrated by the fact that i can associate a product only in home category. So i deleted every categories and this is the result:

 

[PrestaShopException]

Root category must be an integer value
at line 212 in file classes/helper/HelperTreeCategories.php

207. }
208.
209. public function setRootCategory($value)
210. {
211. if (!Validate::isInt($value)) {
212. throw new PrestaShopException('Root category must be an integer value');
213. }
214.
215. $this->_root_category = $value;
216. return $this;
217. }

• HelperTreeCategoriesCore->setRootCategory - [line 2504 - controllers/admin/AdminProductsController.php] - [1 Arguments]
• AdminProductsControllerCore->initContent - [line 189 - classes/controller/Controller.php]
• ControllerCore->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 58 - admin/index.php]

 

This message appear when i click on product section. How i can fix this? ç__ç

[bellini13]

your new issue is completely unrelated to your original topic, I would suggest creating a new topic

[shokinro]

I agree with @bellini13, please kindly create a new topic.