eCommerce construction > How-to questions

all products on

(1/1)

calinut:
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?

Sam_78:
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' .

calinut:
Thank you for the help

Navigation

[0] Message Index