EasyPopulate 4.0 Support Thread

[jiji2018]

Bulk import properties have not been successful, I made the csv table as follows



I manually added the property, after exporting, I changed the model number and want to import it to another product, suggesting that the import was successful, but the product has no display attributes.
“v_products_attributes_id” and “v_products_id” No values are filled in.
I just want to add attributes to the product based on the model.
how should I do?
I tested it on the default zencart system a lot and didn't find a way to use this plugin feature.

[mc12345678]

Bulk import properties have not been successful, I made the csv table as follows



I manually added the property, after exporting, I changed the model number and want to import it to another product, suggesting that the import was successful, but the product has no display attributes.
“v_products_attributes_id” and “v_products_id” No values are filled in.
I just want to add attributes to the product based on the model.
how should I do?
I tested it on the default zencart system a lot and didn't find a way to use this plugin feature.

What is shown is the detailed attribute file. A basic attribute file must be used first to add the attributes to the product and the detailed attribute file then to set the additional properties.

The filename(s) for each are different and must follow the standard as described in the instructions.

[wmorris]

I do have a question if this is possible.....

My warehouse DB uses the Excel or CSV format.

I tie my Excel DB with my Warehouse Excel DB.

I am using the =vlookup command when I use the product number and quantity from the warehouse excel DB and when I use my Excel DB some of my quantities says "N/A" when means either my warehouse doesn't carry that product anymore. When I upload the updated excel to to the it shows those products shows (0) quantities. Is it possible that the N/A can be automatically deleted from the database without me delete it from the database manually?

[mc12345678]

I do have a question if this is possible.....

My warehouse DB uses the Excel or CSV format.

I tie my Excel DB with my Warehouse Excel DB.

I am using the =vlookup command when I use the product number and quantity from the warehouse excel DB and when I use my Excel DB some of my quantities says "N/A" when means either my warehouse doesn't carry that product anymore. When I upload the updated excel to to the it shows those products shows (0) quantities. Is it possible that the N/A can be automatically deleted from the database without me delete it from the database manually?

Could you please clarify? When I first read the message I thought the request was to possibly delete the product from the database, but now it seems like may be asking to delete the text 'N/A' from the product's quantity.

If it is the deletion of 'N/A' I would say that the "better" option is to further use the formulas to detect if the value is N/A and use 0 when it is. The function ISNA supports that.

[jimmie]

i have a custom field in products table called barcode(also known as UPC), when i export this field the values look like this 7.34995E+11, and it imports like this

[mc12345678]

i have a custom field in products table called barcode(also known as UPC), when i export this field the values look like this 7.34995E+11, and it imports like this

In what application does it change to that? I would not expect the CSV file downloaded from the server and opened with a plain text editor to look like that. If the spreadsheet program is used, then it appears that this column should be identified to be treated as text upon import rather than numbers if it allows.

[jimmie]

i open it with microsoft excel

[jodean]

Is the 1.56c version now supported?

[mc12345678]

Is the 1.56c version now supported?

Not 100% sure how to answer this question. As written (which may be related to a language issue) the answer is yes because issues that are identified are corrected. As perhaps understood to be meant, I have been able to successfully use EP4 as provided from GitHub on ZC 1.5.6c. Currently, one of the added features is not 100% complete.

The new feature of using the extension of _en or similar to denote a specific language works for the full import; however, does not for one or two of the other imports.

Note, that this new feature has been incorporated to allow continued use of the import file(s) as they were (a language dependent field ending with the language_id associated with how that database is setup) but it also offers some override type features where if both the language_code (e.g. en, de) and language_id were used then one overrides the other.

Further note, that although I chose to be somewhat forceful in discussion with a recent user at the cost of being seen as a jerk, the information obtained led to a solution that resolved the issues that otherwise were going to be ignored.

As far as the software with Zen Cart 1.5.6c there is nothing done to that version of software affecting this, the issues if any are or expected to be related to php versions.