Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

turning Products on and off


sabreblade67

Recommended Posts

Posted

Is there any way you can turn on or off multiple products instead of 1 at a time? If you load like 1000 or more, that's a lot to turn on. I would appreciate any help. Thank you.

Posted

Is there any way you can turn on or off multiple products instead of 1 at a time? If you load like 1000 or more, that's a lot to turn on. I would appreciate any help. Thank you.

 

you can install special module which allow to disable the whole category of products

http://www.oscommerce.com/community/contributions,326

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Posted

How are you loading your products that doesn't allow them to be "turned on"?

 

blink.gif

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Posted

How are you loading your products that doesn't allow them to be "turned on"?

 

 

 

 

Apsona uploader. I had loaded everything like over 2k of products and after I figured out how to load them in the right spot and right way I looked and they were all off. I made sure by turning a few on then they showed up in my store. which unfortunately I ended up reloading because I had forgotten to turn cache on and when i did my whole store and admin went insane. So have reload all of it again, LOL! "sarcasim with the lol btw"

Posted

Sorry Sabrina but I'm not familar with that program.

 

Most folks here that that want to upload mass amounts of products use Easy Populate (check the add-ons section).

 

Myself, I install my products on my localhost (PC) and then use phpAdmin and update the tables.

 

Good luck!

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Posted

Sorry Sabrina but I'm not familar with that program.

 

Most folks here that that want to upload mass amounts of products use Easy Populate (check the add-ons section).

 

Myself, I install my products on my localhost (PC) and then use phpAdmin and update the tables.

 

Good luck!

 

Thank you.

Well I had read somewhere on how to add products on localhost. I have justhost at the moment. I just can't seem to find it again. Should have bookmarked it that day. I myself would rather do it myself as long as it isn't "copy, paste, repeat" which has been a pain in the past. I refuse to get stuck with a 1 store set-up that I can't control what I add and have to pay a high monthly fee anymore. been working for a month trying to figure this stuff out and eventually I will get the hang of it.

Posted

Thank you.

Well I had read somewhere on how to add products on localhost. I have justhost at the moment. I just can't seem to find it again. Should have bookmarked it that day. I myself would rather do it myself as long as it isn't "copy, paste, repeat" which has been a pain in the past. I refuse to get stuck with a 1 store set-up that I can't control what I add and have to pay a high monthly fee anymore. been working for a month trying to figure this stuff out and eventually I will get the hang of it.

 

Hey Sabrina,

 

Here's a breakdown of how I update and maintain all of my products. It's probably not the fastest or easiest way for some folks, but it works in my situation.

 

My distributors offer me a new database and spreadsheet file weekly containing thousands of items (product ID #, product name, availability, MSRP, NET).

I compare those new files in Microsoft Access with mine and make the necessary changes for adding new products.

I then have to go to the manufactures website to get (copy) the new product descriptions into my Access database file.

My Access database file is setup the same as my live stores tables in MySQL database.

I have a copy of my entire store, incuding the database, installed on my computer running under XAMPP.

So I use phpMyAdmin to import the database tables from my Access file (products, products_description, products_to_categories, etc).

If all looks well, I upload the changed tables to my live online database.

 

I quess most people use the Add-on "Easy Populate" as it is supposed to import the database(s) for you. But since I need to play around with the product descriptions and images I haven't bothered with that contribution.

 

A useful contribution that I use all the time is "Quick Stock Updater" (version 3.5 with the added 3.7 update; newer versions were buggy for me).

I have that installed on both my computers store and my live store.

It allows me in one page to see all my products either sorted by category or manufacturer and quickly update the price, stock levels, etc...

 

My method might not be the best option for you, but maybe you will find something useful. smile.gif

 

Good luck in finding a quick way of maintaining those thousands of products! wink.gif

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Posted

Hey Sabrina,

 

Here's a breakdown of how I update and maintain all of my products. It's probably not the fastest or easiest way for some folks, but it works in my situation.

 

My distributors offer me a new database and spreadsheet file weekly containing thousands of items (product ID #, product name, availability, MSRP, NET).

I compare those new files in Microsoft Access with mine and make the necessary changes for adding new products.

I then have to go to the manufactures website to get (copy) the new product descriptions into my Access database file.

My Access database file is setup the same as my live stores tables in MySQL database.

I have a copy of my entire store, incuding the database, installed on my computer running under XAMPP.

So I use phpMyAdmin to import the database tables from my Access file (products, products_description, products_to_categories, etc).

If all looks well, I upload the changed tables to my live online database.

 

I quess most people use the Add-on "Easy Populate" as it is supposed to import the database(s) for you. But since I need to play around with the product descriptions and images I haven't bothered with that contribution.

 

A useful contribution that I use all the time is "Quick Stock Updater" (version 3.5 with the added 3.7 update; newer versions were buggy for me).

I have that installed on both my computers store and my live store.

It allows me in one page to see all my products either sorted by category or manufacturer and quickly update the price, stock levels, etc...

 

My method might not be the best option for you, but maybe you will find something useful. smile.gif

 

Good luck in finding a quick way of maintaining those thousands of products! wink.gif

 

I need that luck. I to have a few places I can get updates but need the stores taken care of 1st. I will check your way out too. No harm in testing theories. I checked out ep and I got like way confused. I do not give up that easy.

Posted

You can ask some programmer write a add-on for your osc store.

I can give you a solution.

 

Step 1: put all your products in several csv files, maybe each category has a unique csv file.

Step 2: the format of each row like that:

Product ID | Product Name | Product Model(if necessary) | Active or not | Inventory(if necessary)

the values of the field "Active or not" are 1 and 0, 1 for acvite, 0 for inactive.

Step 3: create a new add-on with a upload button in the admin panel.

manage all csv files and make necessary changes, then upload them.

After uploading, your product database will be updated...

Cool!!

Everyone is changing the world.

Everyone is a world.

For everyone needs my help, PM or email if I amn't online.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...