EasyPopulate 4.0 Support Thread

[mc12345678]

Might be able to help, but first need help to give help... It is highly unlikely that anyone else is in front of your computer screen besides yourself to provide indication of what is being performed. Ie, which of the several EP4 file types are being exported. Then which field(s) are being included/modified/deleted from the file. The filename provided will result in processing the file as if it is a full export related file...

As to the error about not importing,that is related (or expected to be related) to the entry not having a model number, letter, or other unique designation for the product.

[ExtensiveEnterprises]

Filterable Exports:
Complete Products

Categories:
Alpha, Limited Edition

Manufacturers:
Wizard of the Coast

Status:
All

I am not modifying any of the first row at all, no editing no deleting.

Generally I often end up with several items all with the same v_products_model - do I need to have unique v_products_model?

[mc12345678]

Filterable Exports:
Complete Products

Categories:
Alpha, Limited Edition

Manufacturers:
Wizard of the Coast

Status:
All

I am not modifying any of the first row at all, no editing no deleting.

Generally I often end up with several items all with the same v_products_model - do I need to have unique v_products_model?

Regarding unique model #s, yes, unique model #s are required for each product that is to be uploaded otherwise the data in (or omitted from) a later entry will populate the earlier entry...

There are a number of ways to rectify duplicate model#s, including using the data exported by eP4, or as necessary additional data added to the export file.

[ExtensiveEnterprises]

Doesn't the system automatically create Product ID's?

[ExtensiveEnterprises]

I suppose what it comes down to is, what is this warning:

No model field in record. This line was not imported Limited E |

and what do I need to do to make my stuff actually import?

[mc12345678]

Doesn't the system automatically create Product ID's?

Yes, ZC provides a unique product_id for each product in the database, though that product_id is likely to be different than the product_id of another store and is not referenced by mass data available from a vendor that provides a product with it's own model#. Also certainly two different vendors marketing two different types of product could have the same model #, but things can be done with that data to make them unique in a store.

So to address the second question (not quoted here) about what it takes to populate the store using EP4. Please do not take any comments/suggestions as anything "personal" or attacking, there is no intention of anything other than providing assistance or indicating information that is perceived to be needed to resolve the issue(s).

1. Please read the instructions that are provided to understand the overall functionality and that a. Model # is required.
2. Populate a product in ZC with information that you would like to see/try to change. (Existing data is fine, but important to understand the data in the database.) This is part of the instructions as well.
3. Download the data to a file. From the above it appears that the data is being prefiltered. There is also an option to download the full product data. This latter option is probably useful for a store that is just starting to use EP4 to ensure that the data is sound for future updates.
4. Maintain the first part of the filename depending on how the data is to be used/manipulated. The specific filename prefixes needed are identified in the instructions. An attributes basic file won't necessarily provide the information needed to populate Stock-By-Attributes, if that plugin is installed.
5. Ensure (like eluded) that the csv file for upload is properly quoted (and escaped). And that the field separator is appropriately identified for the export from the spreadsheet program (expected to be the same separator as in the downloaded csv file.)
6. Attempt an upload of a file with a single product. Even if it is a disabled product. Product should remain in the database unless the status of the product is set to 9 in the upload file. Data related to a product will be "deleted" if the row contains no data in the applicable column. Inthe case of two product having the same model # the data of the last row with that model# will replace any data before that row's entry.

Ought to provide a good starting point.

[ExtensiveEnterprises]

I got it to upload stuff but it will not upload the entire list. It seemingly chooses random items to upload and then doesn't upload the rest.

[RonGin]

I used easy populate to add new products and received error,
1st can I use this to add new products?
2cnd this is the errors I received:
[Import Results


Filename: Full-EP2015Apr29-115223.csv

UPDATED! - Model: E139 | 1 | earrings/E | Fashion de | Cheap whol | | Fashion Ea | Fashion Ea | | | | | | | | 1 | 0.851 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-04-29 | 1 | | Jewelry an | Joyas y Ac | ?^^Earring | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | Cheap whol | Cheap earr | Cheap whol | | | | | | | http://www |
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 0 | Cheap whol | | | | | | | | | |

Finished Processing Import File ]
Can you explain what I am doing wrong?
Thanks
RonGin

[mc12345678]

Looks like the category "escape" code is used without having some sort of parent category...

To have present a pair of shoes that are of a particular style and for a specific gender for example, a category structure such as

shoes -> men -> sneakers could be a category structure. In the default version of EP4, this is represented as: shoes^men^sneakers

Above, I see an example of ^^Earring which could potentially indicate that he category Earring is underneath two blank categories.. That seems like it could present an error. Would almost need to see the raw data (CSV file) to provide a clearer explanation.

As for adding product, most certainly, every product must have a unique model #, and that model # must be included in the file being uploaded.

[ExtensiveEnterprises]

Easy Populate 4

Back to having issues, this program has yet to work correctly. Any help on what I am doing wrong would be greatly appreciated!! I keep getting this error:

No model field in record. This line was not imported

What am I doing wrong to get this error?

I have uploaded the csv with nothing in the v_products_model column, then again with the same thing for every product, then with different things for each product but i'm getting this message every time.