Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chadderuski
Hi Diva!
Well, the custom products fields only work with the products table. If the is a special table for stock by attributes, I'd need the details on that. Depending on the complexity of that add on, it may be "easy" to add a new table to the logic ... send me a pm and perhaps we can work on this off line. I am a tad busy at the moment, but there is always a free time here and there...
Hello back!!!
**waves furiously**
Yep there is a special table for SBA, and I will PM you my e-mail address and we can discuss offline as BOTH of our schedules permit!:laugh:
Quote:
Originally Posted by
chadderuski
You read all 51 pages? :0
Yes sir I did!!:laugh: I ALWAYS read through support threads of mods I'm interested in using.. This way I get a sense of the history of the add-on, a sense of how stable it is or isn't (I wasn't worried about stability with this one knowing it was your baby:smile:), and mostly to get acquainted with things before I dive in..
Re: EasyPopulate 4.0 Support Thread
I really need some help. I have 2 issues..
Issue #1 I have about 1,000 attributes. what is the easiest way to place all the attributes and information in the 1.correct columns of the attribute file. For example: v_attribute_options_name_1_1. I have to create v_attribute_options_name_2_1, v_attribute_options_name_3_1. 1,000 times. Then I have to do the same thing with v_attribute_values_name_1_1_1. etc.. for all the different fields,
So all these fields would have to be filled in at least one time before I can copy them down on the csv spreadsheet.
v_products_model v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_1 v_attribute_values_id_1_2 v_attribute_values_price_1_2 v_attribute_values_name_1_2_1 v_attribute_values_id_1_3 v_attribute_values_price_1_3 v_attribute_values_name_1_3_1
Issue #2 So each for each item (v_products_model) I would have to put a 0 in each v_attribute_values_price_1_1 field related to that product model.. Does anyone have or know of a program or excel formula that would auto copy correctly the 0's that are needed in this field to matcht the product model to the attribute.
I have a database with the correct attributes to choices for each item
Not sure if this makes sense to anyone, other than someone who has experienced this as well.
Thanks to anyone who can assist..
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
dlwwalton
I really need some help. I have 2 issues..
Issue #1 I have about 1,000 attributes. what is the easiest way to place all the attributes and information in the 1.correct columns of the attribute file. For example: v_attribute_options_name_1_1. I have to create v_attribute_options_name_2_1, v_attribute_options_name_3_1. 1,000 times. Then I have to do the same thing with v_attribute_values_name_1_1_1. etc.. for all the different fields,
So all these fields would have to be filled in at least one time before I can copy them down on the csv spreadsheet.
v_products_model v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_1 v_attribute_values_id_1_2 v_attribute_values_price_1_2 v_attribute_values_name_1_2_1 v_attribute_values_id_1_3 v_attribute_values_price_1_3 v_attribute_values_name_1_3_1
Issue #2 So each for each item (v_products_model) I would have to put a 0 in each v_attribute_values_price_1_1 field related to that product model.. Does anyone have or know of a program or excel formula that would auto copy correctly the 0's that are needed in this field to matcht the product model to the attribute.
I have a database with the correct attributes to choices for each item
Not sure if this makes sense to anyone, other than someone who has experienced this as well.
Thanks to anyone who can assist..
Hi Walton,
I think you are mixing up EP 4.0 with some other version of EP. I EP4 the _1 refers to language 1 (i.e. english by default in most installs). So you would never have something like _1_1, _1_2!
I would suggest that you take one of your products, and from within the admin, correctly create your attribes on that product. Then export the basic attribute sheet. This will provide a road map for you... and please read the (admittedly scant) documentation no attribute importing from the download package.
Hope this gets you started on the right foot.
-chadd
Re: EasyPopulate 4.0 Support Thread
That's exactly what I did. Was export after creating a few in the admin. I am not sure what version I of EP i have. I looked at the admin/tools/EP but I don't know the version. What I downloaded was for Zencart 1.5. I will look for it. However I will I still have the same issue with trying to place each attribute in the correct column 1 at a time?
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
dlwwalton
That's exactly what I did. Was export after creating a few in the admin. I am not sure what version I of EP i have. I looked at the admin/tools/EP but I don't know the version. What I downloaded was for Zencart 1.5. I will look for it. However I will I still have the same issue with trying to place each attribute in the correct column 1 at a time?
My version is available here at github as version 4.0.22 - Beta 6-10-2012 which is displayed on the Easy Populate 4 tools page.
https://github.com/chaddro/EasyPopulate-4.0
-chadd
Re: EasyPopulate 4.0 Support Thread
chadderuski
Thank you I have 1 question. Can I use the same product number for my items in v_products_id and in v_products_model..If not does that mean I have to create the same number for each of the same v_products_models. Did that make sense?
Re: EasyPopulate 4.0 Support Thread
chadderuski
One more thing. Using you latest mod now. Inserted about 10 products with attributes. Downloaded the FullEP and AttributesEP files. Then deleted the products in admin. Tried to import the products back no problem. Imported the attribute file and it imports with no errors but the attributes don't show up. What am I doing wrong?
Also I don't understand what you mean by "please use OpenOffice to Export your CSV file" I am using Open Office but how do I export using Open Office?
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
dlwwalton
chadderuski
Thank you I have 1 question. Can I use the same product number for my items in v_products_id and in v_products_model..If not does that mean I have to create the same number for each of the same v_products_models. Did that make sense?
Are you referring to the detailed attribute sheet? If so, you do not modify ANY of the first several columns. I've explained this before. You have to create your BASIC attributes first. Then you can download and set all the micro information with the DETAILED sheet. You have to remember that the detail sheet refers to a specific product+option name+option value in the database. So you cannot modify the first columns.