Author Topic: all products on  (Read 596 times)

Offline calinut

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
all products on
« 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?

Offline Sam_78

  • Full Member
  • ***
  • Posts: 142
  • Karma: +21/-1
    • View Profile
Re: all products on
« Reply #1 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' .

Offline calinut

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: all products on
« Reply #2 on: October 09, 2017, 05:42:35 PM »
Thank you for the help