Re: Easy Populate support
Quote:
Originally Posted by bettysue
also, in the store template the field v_tax_class_title has the sample field as:
--none--
am I supposed to keep the dashes in it?
b
This merely reflects the name of your tax class for a particular product. In you Zen Cart store, you have the option "--none--" which is why Easy Populate exports it. It means you have no tax class assigned to that product.
Re: Easy Populate support
sorry Langer, will go back to yourforums for question.
betty
Re: Easy Populate support
Greetings,
Thankyou for your help Ryk and Dr.Byte! :D I have now successfully uploaded my Easy Populate Mod and it is showing this in the Tools menu of the Admin panel. I have also configured everything. My next step is to upload an .xls (Excel) file to my site. This I am unsure how to do. I have searched the threads in an effort to learn how, but could not find the specific instructions I need.
I basically have an Excel spreadsheet with 4 tabs and an average of about 1375 sports trading cards on each tab. In the spreadsheet, the sports cards are organised by 8 different categories (Year, Company, Special Notation, Player, Card #, Condition, If #, and Price). I was just wondering if there is a special way to do this, or if it is even possible to accomplish uploading a sheet of this type to my database through Easy Populate?
I really appreciate all your help guys. Thankyou in advance :smile:
In Christ,
Jesse
Re: Easy Populate support
Jesse - the only way that you can import via EP is to use a tab delimited text file. You can use Save As from Excel for this but it will only save a "flat" file...therefore you'll need to modify your xls
Also, there is a very specific format to follow, so your best bet is to download your existing products via EP and use that as your template.
If you haven't got product data yet, then just add a test item with as much info as possible to give you guidance.
Re: Easy Populate support
Code:
Warning: require(includes/extra_datafiles/easypopulate_filenames.php) [function.require]: failed to open stream: No such file or directory in /home/cgc/public_html/store/admin/includes/init_includes/init_file_db_names.php on line 39
Fatal error: require() [function.require]: Failed opening required 'includes/extra_datafiles/easypopulate_filenames.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/cgc/public_html/store/admin/includes/init_includes/init_file_db_names.php on line 39
What am I doing wrong?
Re: Easy Populate support
I'm getting "0" for categories when inserting my Easy Populate files. I made sure I deleted all 0's from my excel files and txt files but easy_populate seems to treat the blank cells as 0 for category. Does anybody have any suggestions?
Re: Easy Populate support
Is there a value for Easy Populate that I can use to indicate if the product is refurbished. i.e Product Name equals "v_products_name_1".
Re: Easy Populate support
Does it work with price breaks? All my products prices are set this way. Is there any other way to update they quickly?
Adam
Re: Easy Populate support
Nevermind, i fixed my prob :D
Re: Easy Populate support
Thanks Ryk! I appreciate your help! I have successfully uploaded the first sheet of cards. The only problem I'm having currently is that I uploaded one sub-category too many and am trying to find a fast way of deleting it out of each category in which it was placed. (E.x. I have different years listed in the "v_categories_name_3" column of the tab-delimited .txt file I uploaded to EP, and "NM-MT" in every field (approx. 200) the "v_categories_name_4" column of the same .txt file. I decided, after accidentally uploading this .txt file that I didn't want the "NM-MT" category anymore, but found that the only way I knew how to delete it from every year category was to do so manually through the ZenCart admin panel.
If there is any way of accomplishing this much quicker, pehaps automatically somehow, I would really appreciate if someone could help me understand how to do so. Thanks in advance for all of your help, and thanks again Ryk for your assistance! :D