Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some investigation and get back to you if I find an answer. You should email the people at iPage as they probably could give you an answer..
That is the problem. We do have to worry about stock levels, at least at the supplier. We can populate the database with all of the available products but we don't want people ordering things that aren't in stock just to recieve an e-mail stating that the product isn't available and must be back-ordered. We are wanting to keep the quantity of the items in the database updated at least daily. Would be great if there was a way that the database quantity field would pull it's value from the excel file (that we can download each day)and from the correct line. Any ideas????..
I think it is possible to do this by having a special script written which takes info from say a CSV file and puts the information directly in to the database tables matching the product ID if you use the same ones as your supplier..
You could upload the suppliers file and run the script to do it whenever you need to..
The only question is - who can you get to write the script ???..
Did you ever figure out something for this?.
Please let us know.
I don't understand what the problem is. If your new list shows that the inventory quantity is '0', and you track inventory in your store, then the product would not be available..
The only way you would run into a problem is if Monday's list showed Widget A with 10 units, and then Tuesday's list didn't list Widget A at all, because it is sold out. If this is the case, then you would need to take your current store inventory, and find the items not listed in the new list, set those to 0 quantity. Best thing to do would be to run a small sql script that set all inventory to '0' just prior to importing the new list, and then nothing would get missed..
Of course, I believe most wholesalers will list items even if 0 quantity, at least for a while..
What am I missing?.
Iam not sure if this is the problem that others are having, but here it is:.
Stock quantity need to be updated regualarly. Since the distributers provide me with an .csv file contaning all the quantities for items, I need a way to be able to import that file to the database product to update the quantity in my store..
Of course I can do it manually but that would be painfull because I would need to be updated almost every 30 minutes or so. So what we are looking for, I think, is a script that would match products in the csv file to the one in the database, then it would update the correct quantity from the .csv file..
Please correct me if I am wrong..
You are correct. I have a csv file that I can donload daily and need a way to update item quantities. I have figured out a way... I an currently useing ms access to link to the mysql database. I then import the csv file and do an update query between the 2 tables which are linked by the item id. This does update the quantity as well as the price.
Seems to work fine. I am in the process of doing a query that takes the quantity filed from the imported csv file and if the quantity is "0", the item will show out of stock..
If anyone could use this for their site, let me know and I will work with you to get you set up if you don't know what to do in ms access and querys. I don't know it that well but I do know how to do what I did! LOL..
Thanks for the help..
However, Like most people on this fourm, I can't link between Access and the SQL database because my host will not allow it (ODBC)..
I thought of doing that but the problem above came up. Is there any way of coming up with a code so it can be schedualed in as a task. I am sure that Access shows you the sql code for the query that you do. I'll look around, please let us know if you get anything..
I wasn't sure where to post this, so I posted it here....
We have an osCommerce iPage site up and running but have a question. We don't plan on stocking any inventory. We have a supplier that carries all the items that we offer and we are able to download a comma seperated file that lists all of the items and their current status and quantity. With this file, we can populate the iPage site easily with Easy Poplulate, but when you have over 6000 items that you can list on the iPage site to sell, keeping up with available inventory becomes a problem... Does any one know of a way that this can be accomplihed without too much work each day. We are able to download the product/inventory file daily..
If you go to admin/ configuration/ stock / check stock level and set this to false you will not have to worry about your stock levels at all...