ixbiosxi Posted January 29, 2003 Share Posted January 29, 2003 I was wondering if it was possible to import an access database that contains all my products instead of rekeying every damn item. I have somewhere around 25,000, thats alot of room for error Is it also possible to use the attributes options to where if they select one color it only show available sizes for that color. I have somewhere around 30 colors per item and 10 sizes per item but only 7 of those sizes are available in all colors. For an osCommerce and STS Tutorial click the www button in my profile. Link to comment Share on other sites More sharing options...
Guest Posted January 29, 2003 Share Posted January 29, 2003 Not sure, but i think there may something in downloads/contributions Link to comment Share on other sites More sharing options...
ixbiosxi Posted January 29, 2003 Author Share Posted January 29, 2003 i saw the contribution, what i need to be able to do is upload or import my product.mdb file into oscommerce so i dont have to rekey 25,000 items. also when i change prices 2-6% next year i dont want to have to manually rekey everything again in my visual manufacturing database. For an osCommerce and STS Tutorial click the www button in my profile. Link to comment Share on other sites More sharing options...
kn1ght Posted January 29, 2003 Share Posted January 29, 2003 What I did is import all to excel, edited it. Then from excel you converted them back to the original format. Link to comment Share on other sites More sharing options...
ixbiosxi Posted January 30, 2003 Author Share Posted January 30, 2003 i guess my question is how do i import the products into the shopping cart, and what fields do i use for identifiers like price, size, quantity and so on. For an osCommerce and STS Tutorial click the www button in my profile. Link to comment Share on other sites More sharing options...
loxly Posted January 30, 2003 Share Posted January 30, 2003 Go to the contributions section and download and install the Easy Populate contribution. It is an easy contrib to install, so hopefully you won't have any problems. Then follow the directions to export your products to an excel download. This will give you the format and field names that it can import. You can open your db in excel and copy/paste the tables into the correct order. Then you can upload the products to the osc database using the same Easy Populate program. There are directions for splitting the file if it is too large to load all at once. Â Unfortunately the attributes are stored separately, so you will also need the Attributes Sorter and Copier contribution to add similar attributes to a large group of products. Â I don't know if there is another way around it other than a custom made upload or if that is even possible. Â Debbie [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
ixbiosxi Posted January 30, 2003 Author Share Posted January 30, 2003 what file in osc do i edit to allow me more than 12 characters for a product model. For an osCommerce and STS Tutorial click the www button in my profile. Link to comment Share on other sites More sharing options...
rseigel Posted January 30, 2003 Share Posted January 30, 2003 Edit the field in the database directly. Link to comment Share on other sites More sharing options...
ixbiosxi Posted January 30, 2003 Author Share Posted January 30, 2003 ok what can i use to edit the database. For an osCommerce and STS Tutorial click the www button in my profile. Link to comment Share on other sites More sharing options...
ixbiosxi Posted January 30, 2003 Author Share Posted January 30, 2003 nm i got it For an osCommerce and STS Tutorial click the www button in my profile. Link to comment Share on other sites More sharing options...
loxly Posted January 31, 2003 Share Posted January 31, 2003 You need to edit the corresponding entry in EasyPopulate.php if you are using it. [no external urls in signatures please, kthanks] 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.