AbanteCart Community

eCommerce construction => How-to questions => Topic started by: calinut on October 09, 2017, 03:09:37 PM

Title: all products on
Post by: calinut on October 09, 2017, 03:09:37 PM

Is there a way to make all products turned on or show after csv import instead of haveing to go through and enable each product which is such a pain when you've uploaded 1600 products?

Title: Re: all products on
Post by: Sam_78 on October 09, 2017, 04:11:29 PM

You can do this through Query.
UPDATE `products` SET status = 1;
but this will turn on all your product and there wont be any way to go back
Example:
('product1', 1),
('product2', 1),
('product3', 1),
('product4', 0),
('product5', 0),
('product6', 0);

after running this query all of the products would turn on:
('product1', 1),
('product2', 1),
('product3', 1),
('product4', 1),
('product5', 1),
('product6', 1);


So if you want to go back to normal after you made your CSV you cant go back to original as all the products are turned ON then you manually have to turn them off.

The other solution is edit your CSV file.  you can do it using excel update `status` column values to '1' .

Title: Re: all products on
Post by: calinut on October 09, 2017, 05:42:35 PM

Thank you for the help