Guest Posted March 15, 2007 Posted March 15, 2007 I've tried using a couple of the Contributions that promise Easy Population of a vast inventory, but to no avail - none of them are easy. I'm way behind in my project now, and am hoping that there is someone who can offer me some assistance in this... ...about 1000 items... there's no way i can manually input them. *** i have an xls file that i created to coincide with the products and products_description tables and successfully populated these database tables this way, but the items aren't showing up in OSC - i'm obviously missing some tables and i realize that tracking down all the tables that are necessary would be very tedious. any help...? thanks for any help you can give. Glenn Nall
vasttech Posted March 15, 2007 Posted March 15, 2007 you need to populate the products_to_categories table as well. That way your products know where to show up :). If you have no categories configured you should do that first. osCommerce Knowledge Base osCommerce Documentation Contributions
Guest Posted March 15, 2007 Posted March 15, 2007 thanks - got products_to_categories populated, still nothing shows up in the website - that's products products_descriptions products_to_cat. is there anything anyone can see i've missed i've missed? you need to populate the products_to_categories table as well. That way your products know where to show up :). If you have no categories configured you should do that first.
vasttech Posted March 16, 2007 Posted March 16, 2007 Did you have your categories setup prior to doing that and when you populated the products_to_categories table did you put the products in the right category ids? osCommerce Knowledge Base osCommerce Documentation Contributions
Guest Posted March 16, 2007 Posted March 16, 2007 thanks, Jeff, i figured it out - had to change language_id and products_status values to 1... thanks for your help... it's a shame Easy Populate ISN'T.
vasttech Posted March 16, 2007 Posted March 16, 2007 No problem. Ah, the languages was going to be my next response but I didn't think about the status. Yeah, Easy Populate can be a little hard for to comprehend. I am still partial to creating a CVS file from an Excel spreadsheet and importing it that way. Quicker and easier I think. Anyway, glad you got it. osCommerce Knowledge Base osCommerce Documentation Contributions
♥bruyndoncx Posted March 16, 2007 Posted March 16, 2007 good you've loaded up your stuff, however EP is handy later on to quickly scann the data in your shop or focus on certain categories and/or manufacturers. I strongly advise to try to get EP setup so you have an easy way to do batch updates. For me it has been a real time saver. KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
Recommended Posts
Archived
This topic is now archived and is closed to further replies.