Reset massively stock of products imported from Vi

  • Posts: 86
  • Thank you received: 2
11 years 6 months ago #100075

Good afternoon.

I'm upgrading a Joomla 1.5 with Virtuemart to Joomla 2.5.9 with HikaShop Business 2.1.2.

In Joomla 1.5 installed HikaShop and import all products Virtuemart to HikaShop. Then from HikaShop export all products in csv format.

Later, in Joomla 2.5.9, import from the file csv HikaShop.

The only drawback that I have is that all products put as "stock 0" and at the front of the website below each product "sold".

Is there any way for you to modify the stock of all products massively em?

There are many products and it becomes difficult to go changing the stock to each.

HikaShop When I delete the amount of stock of any product disappears marked "sold" and I aparce the button "buy" that's what I want. But I need to do it en masse.Thank you very much from now.

Pdt: excuse my English.

Please Log in or Create an account to join the conversation.

  • Posts: 82761
  • Thank you received: 13348
  • MODERATOR
11 years 6 months ago #100082

So you want to have all the products with the stock unlimited ?

In that case, you can run the query below in your phpmyadmin:

UPDATE #__hikashop_product SET product_quantity=-1 WHERE 1;

Makre sure to replace #_ by your table prefix.

Please Log in or Create an account to join the conversation.

  • Posts: 86
  • Thank you received: 2
11 years 6 months ago #100105

Nicolas.

I solved by editing the csv file, placing the entire column without values ​​and driving her to import.I also consider his explanation pra similar cases in the future.Thank you very much.

Please Log in or Create an account to join the conversation.

Time to create page: 0.056 seconds
Powered by Kunena Forum