Guest Posted May 16, 2015 Share Posted May 16, 2015 Support, First I like to thank you for your oscommerce as this a great stepping stone to creating a perfect site. I LOADED OSCOMMERCE 2.3.4 I can get an updated file everyday to tell me the suppliers status, this EXCEL.XLSX; FILE GET DAILY 6AM ALL PRODUCTS STATUS. I LIKE TO DO A IMPORT OF EXCEL.XLSX TO THE DB MySQL, SO MY COMPLETE WEBSITE IS UPDATED WITH IN MINUTES WITH THIS DAILY REPORT. CAN YOU HELP? I added column S wher I excel calculate my selling price T Is equal to the main CATEGORY U Is equal to the main CATEGORY SUB LVL, NEW CATEGORY V Is equal to the main CATEGORY SUB LVL, NEW CATEGORY next SUB LVL, NEW CATEGORY (yes three levels) V SUPPORT A COMPLETE SUB CATEGORY TO ALLOW LISTING THE GROUPS OF PRODUCT FROM "H" Column A - I=INSTOCK | O=OUT OF STOCK Column B - QTY ON HAND Column C – DISREGARD Column D – DISREGARD Column E - WHOLESALE ITEM NUMBER Column F - MFR PART NUMBER Column G - UPC Column H - PRODUCT CAT Column I - MFR BRAND NAME Column J - YOUR WHOLESALE PRICE Column K – DISREGARD Column L – DISREGARD Column M – DISREGARD Column N – Weight Column O - PRODUCT TITLE Column P - PRODUCT DESCRIPTION Column Q - IMAGE URL Column R - MFR SUGGESTED RETAIL PRICE Column S - MY WEBSITE LISTED PRICE Column T – CATALOG DIR (TOP) Column U – CATALOG SUB CAT OF TOP Column V – CATALOG SUB-SUB CAT OF TOP Regards, Dennis Link to comment Share on other sites More sharing options...
MrPhil Posted May 16, 2015 Share Posted May 16, 2015 Take a look at the "Easy Populate" add-on. It takes a CSV format spreadsheet (list) and imports it into the osC database. You would have to take your Excel spreadsheet and export it as CSV first. Link to comment Share on other sites More sharing options...
Guest Posted May 16, 2015 Share Posted May 16, 2015 Phil, Thank you for your input, as I am very new to oscommerce. Regards, Dennis Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.