Good question... I dunno what is the right answer to your question. I'll do some investigation and get back to you if I got an good answer. You should email the people at iPage as they probably know..
Sorry, I wanted to consolodate all the info that I put in my last thread. To make it more readable. I did not want to cause any problems. Thanks for the help you gave me though.
In the future I will try to get it right the first time!..
Anyone know what a CRON job is? Someone said it might help me...
Once you have your program that updates the inventory based on the file received, you then define a cron job to do this automatically..
Cron is a unix program that will look for jobs to execute on a set time or every x hh/mm or so. It's to automate repeating tasks...
Does anyone think that this is actually possibe? To make this process totally automated without having to manually import every time? Can I do it without a cron job? Will it require extensive modification of oscommerse? Thank You for your input thus far! I really do love this forum!..
I sell products with the dropship method with OsCommerse. The company that dropships for me has a system that automatically updates my stock levels to their current inventory via FTP. They send me a .txt file with the product quantities in it. What I need is someone to make Oscomerse take this information from the .txt file and show product quantity just like it normally does, but get the quantity FROM the .txt file. I want it to be automated once I set it up. I want Oscommerse to automatically check to see if the inventory file has been replaced with a new one.
(it is tab delimited):.
Summary of what every column is:.
All that matters to me is column 1 and 2, the rest is useless!.
Column1: SKU Sorted by item number (SKU).
Column2: available (current, unadjusted, available quantity) This is what is available for you to sell.
Column3: openpo (quantity on order) This is what we have on order with our supplier.
Column4: exprecdate (earliest expected receipt date for orders) This is only a best guess when we’ll be receiving these items.
Column5: status (D- Discontinued; O- Special Orders; P- Pre-Sell; S- Stock) This tells you if an item is something we stock, has been discontinued, can be pre-ordered, or it is a special order..
Column6: cost (dealer cost) This is the cost you will pay us, exclusive of any fees.
Column7: msrp (retail price) This is the price suggested by the manufacturer that you sell at.
I don't care about all the other info in the .txt file. All I want is the product number and the product quantity. (obviously because The product quantity must be associated with the product number)..
Why are you doing another thread when you already have an open one?.
Makes me not want to...