Easy Populate 1.2.5.4 support

[johnd]

Thanks Awev -- perhaps it is the timing that you mentioned. I'll check that on my next upload.

Awev

My next upload worked perfectly. All of the images were displayed as I had hoped they would be. Thanks for your support.

[Jules4Love]

Hi,

I need urgent support for Easy Populate Standard. I am currently setting up a shop front for a Printing company using Zen Cart. The company have four main print sizes.
I need to find a way of creating bulk quantity discount for each of these print sizes.

The first print size retails at $7.50 for the first print and 50 cents for each additional prints. An easy calculation of $7.50 + (Quantity * 0.5).

The second print size $10 for the first print and $2 for each additional prints.
The third print size $12.50 for the first print and $4 for each additional prints.
The fourth print size $12.50 for the first print and $5 for each additional prints.

I have investigated how I could configure categories with specific quantity discount but this has not worked. I am hoping to get advice about how I can modify PHP codes if necessary or use Easy Populate to achieve this.

Thank you in advance
Jules

[kobra]

The first print size retails at $7.50 for the first print and 50 cents for each additional prints. An easy calculation of $7.50 + (Quantity * 0.5).

The second print size $10 for the first print and $2 for each additional prints.
The third print size $12.50 for the first print and $4 for each additional prints.
The fourth print size $12.50 for the first print and $5 for each additional prints.

Do this with attributes

[jayenne]

Hi all, I have written a tutorial explaining the steps and processes involved with importing Attributes using easy populate - I hope it helps.

If there are miss understanding on my part leading to errors please forgive me, correct me then sue me ;)

• on that not I would like to say, BACKUP! then BACKUP AGAIN! any loss of data remains your loss NOT mine - I accept no liability whatsoever for any damage, harm or act of god resulting from you following this tutorial (Phew - close one)....
• ...Also, for a pretty version with tabular examples CLICK HERE

HOW TO: prepare and import an Attribute file using easy populate...

Login in to the backend of your website.

You should ensure that all options and attributes that may be used by any of the products you wish to import, have been created and are correct.

Select from the top menu: tools > Easy Populate

From the right column under Data Files, select Attributes - this will export the current attribute data from your site.

Select Save from the newly created attributes row within the table to save the attributes file to your computer.

You now have a popup window asking you to open/save the file… Save this file to a location on your computer then import this file into Excel (or equivalent) as a tab delimited file.

Reading and understanding the file format, row & columns….

Note: Within the new excel worksheet you will now see a set of headers on the first row (these should never be altered). Each subsequent row is the attribute details of a single product.

For each row, the columns read as follows…

PRODUCTS….

v_products_id = The products ID number... e.g: 375
v_products_model = The products Model number... e.g: 123987

The first two columns v_products_id & v_products_model identify the product you wish to add the attributes to. These columns are the products ID and the products model number.
The product ID is required, the model number is not – however it is a safeguard and should be included where possible.

The following columns may be described as a horizontal list of options and their attributes. An option may have many attributes just like a Size option may have ‘small’, ‘medium’ and ‘large’ attributes.

There are three basics you will need to understand regarding the rest of the columns to understand this tutorial… ‘Option types’, ‘Attributes’ and ‘Option-Attribute Sets’

‘Option types’ are Size, Colour or Weight etc.
‘Attributes’ are the values available for each ‘Option-type’ such as ‘Red’, ’Green’, ’Blue’ or ‘100kg’, ‘500kg’, ‘1 Tonne’ etc.
‘Option-Attribute Sets’ are ALL columns that relate to a single Option + Attribute and share a common suffixed ID within the column name.
With that cleared up, let’s move on….

The column headers are variable and as such I can not give column ID’s from here on but rather detail the requirements for each ‘column type’ and its purpose so read carefully…
NOTE: For every ‘option type’ there must be at least one attribute and for every set of attributes there must be an option type given.

OPTIONS….

The ‘v_attribute_options_id_1’ and ‘v_attribute_options_name_1_en’ columns identify the type of option you wish to add to a product such as Size, or Colour etc. These should have already been created within the backend of your store and are case sensitive.
NOTE: Should you require a NEW option name for your import you will need to first ADD the name in the backend via the top menu > catalog > ‘option name manager’ then use the new name and newly assigned ID

NOTE: the suffixed number is an identifier for the ‘Option-Attribute set’. An ‘Option-Attribute set’ is an ‘Option type’ + all the Attributes for that Option. A row may have as many Option-Attribute sets as desired and may occupy any amount of columns but ALL must follow the rule noted above.

So what do these Options columns mean?

v_attribute_options_id_1 = The ID of the option type... e.g: 1
v_attribute_options_name_1_en = The name of the Option type... e.g: Size

ATTRIBUTES….

The following three columns are required for EVERY Attribute. These three columns are repeated along the row for each attribute product requires.. e.g. one set of three for each colour of a particular product you have… Three columns for Red, three for Green, three for Blue and three for Yellow etc.

Product 1 : Attribute 1 (colour RED) =
v_attribute_values_id_1_1
v_attribute_values_price_1_1
v_attribute_values_name_1_1_en

Product 1: Attribute 2 (Colour BLUE) =
v_attribute_values_id_1_2
v_attribute_values_price_1_2
v_attribute_values_name_1_2_en
… etc

The repetition of ‘Option Type’ followed its ‘Attributes’ as ‘Option-Attribute Sets’ should be maintained until the final ‘Option-Attribute Set’ required has been included.

The final column of any row must be EOREOR this tells the program that it is the ‘End Of Row’ and that the new product will listed next.


So what do these attribute columns mean?

v_attribute_values_id_1_1 = This is the ID of the attribute... e.g: 5


v_attribute_values_price_1_1 = This is the Price of the attribute... e.g: 9.99

v_attribute_options_name_1_en = This is the Name of the attribute... e.g: 1kg

NOTE: The price value is excluding tax and defaults to a + value. i.e. the product price PLUS this attribute price.


VALUES…

The values required for these columns can be found in a number of places and a small amount of backend preparation will save to time in creating your file.

Where do I find the values required for all my rows?...

v_products_id (database table: products.products_id)
• This number is found as the ID (first) column when listing the product in the backend
• By hovering over the image or title/name of the product within the frontend
• By exporting the store from easy populate and reading the number given in the v_products_id column of the row for your chosen product
v_products_model products.products_model • This number is found as the ‘Model’ (third) column when listing the product in the backend
• By reading the Product/Model Code: xxxx within the frontend
• By exporting the store from easy populate and reading the number given in the v_products_model column of the row for your chosen product

v_attribute_options_id_1 (database table: products_attributes.options_id)
• This number is found as the ID (first) column when viewing the ‘option name manager’ in the backend. (top menu > catalog > option name manager)

v_attribute_options_name_1_en (database table: products_options_values. products_options_values_name)
• This number is found as the ‘Option Name’ (second) column when viewing the ‘option name manager’ in the backend. (top menu > catalog > option name manager)

v_attribute_values_id_1_1 (database table: products_options_values.products_options_values_id)
• This number is found as the ID (first) column when viewing the ‘option value manager’ in the backend. (top menu > catalog > option value manager)

v_attribute_values_price_1_1 (database table: products_attributes.options_values_price )
• This number is found as the fourth column when viewing the selected product within the ‘Attributes controller’ in the backend. (top menu > catalog > Attributes Controller.. Select category… select product… click [Display] button)

v_attribute_values_name_1_1_en (database table: products_options_values.products_options_values_name)

• This number is found as the Option Value (third) column when viewing the ‘option value manager’ in the backend. (top menu > catalog > option value manager)

Now save the file as a TAB DELIMITED FILE from Excel (or equivalent) ready for importing.

The import process is almost the same as export as you are required to log in to the backend then via: Top menu > Tools > Easy populate you should select the [Browse] button > search for the file you have just saved then click the Import and wait for the success or failure message on completion of the file processing – it will appear just below the top menu.

If all is well, go check your products with there new shiny attributes. If all is NOT well read the accompanying error messages and figure out where these instructions are deficient then let me know where I went wrong 


Hope it helps - and if there are mistakes please post them so I may make the corrections (and understand it better )
Jayenne

[elkbow]

Hi everybody above - Repete Post...
I have been using EP 1.2.5.4 now for two weeks and can only get the Full Download/Full upload to work.

The Download of the following returns a notice in Excel of "Incomplete Download". Thus these portions do not work for me.

Model/Price/Quanity
Model/Category
Model/Attributes

Those three downloads have incorrect data. Example: The Attributes when downloaded show up as every item has the same attribute as the very first item I added. Therefore I cannot upload any attributes this way. With 6300+ products it's taking a LONG time to put in these attributes. Some products have up to 60 attributes.

I reinstalled the EP and same result.

Help would be appreciated...
Thanks

[SPH]

Example: The Attributes when downloaded show up as every item has the same attribute as the very first item I added. Therefore I cannot upload any attributes this way. With 6300+ products it's taking a LONG time to put in these attributes. Some products have up to 60 attributes.

I reinstalled the EP and same result.

Help would be appreciated...
Thanks

All attributes showing on all downloaded products happened to us, I suspect that's just the way it is. Actually, we cannot download all of our attributes as the spreadsheet "times out" at column IV.

[Scrat]

SPH & elkbow - I had a problem but that I could not download my attribute file at all it just hung.
Have you tried to save to temp file and then download via FTP. Mine was a hosting problem!

[james739]

How to do include the legend for my product attributes. For example, I want to enable "required" for all my size options and enable "display" for my select option. I setup 5 products with this option, then exported the .txt file to excel, but the changes did not show in the spreadsheet.

How can I resolve?

Your help is appreciated! Thanks!

[Scrat]

james739 - Sorry I don't really understand what you are asking for ?

I see you have shoes sizes are you asking to show all the sizes available ? in the attributes upload file.
If so you need to put a '0' or '+1.00' etc in the attribute column you require for it show in the product.

[SPH]

SPH & elkbow - I had a problem but that I could not download my attribute file at all it just hung.
Have you tried to save to temp file and then download via FTP. Mine was a hosting problem!

We can download okay from EP. It's just that Xcel and Open Office spreadsheets apparently don't go beyond column IV. We have so many attributes and every attribute seems to appear on each product downloaded.

Haven't tried FTP, but should still have same problem with limits of spreadsheet column number.