I have an existing OSCommerce site with attributes of color and sizes. I need some modifications made so that I can use .csv / excel file inventory feed that my suppliers give me to show real-time inventory stock on my site.
The csv/excel file feeds are set-up like this: (Stock-by-Attributes)Product A: (size 5.5, color white) in stock Product A: (size 4.5, color white) NOT in stock Product A: (size 4.5, color red) in stock Product B: (size 5.5, color white) NOT in stock Product B: (size 4.5, color white) NOT in stock Product B: (size 4.5, color red) in stock.
My site has the basic attribute options but I want it set up like the above example so that my site will work with the excel feed
I need: 1. Change my attributes module to Stock by Attributes module
2. write a program to update the feeds to stock qty
3. show in product page side...if a size is selected...color will change to show only available products, and vise-versa.
4. To setup so the feed will update daily (I will have 4 suppliers w/ 4 feeds)