EasyPopulate 4.0 Support Thread

[mc12345678]

That's a lot of digging, thanks! I'm not comfortable testing the untested code on this live site. But I do understand the problem much better. I'll get back with my client with some options for him. I'll try again to convince him to use Model Numbers.

Model number won't specifically resolve the issue and is not specific to causing the observed response(s).

Does the store perhaps use products_sku and applied a suggested implementation that was posted earlier in this thread? Basically, if search for EP4_DB_FILTER_KEY to see if it is used outside of the core files in the root of the admin, the extra_functions folder of the admin and/or the admin's modules folder.

Note for others, the plan is/was that if an alternate filter option were desired/to be used, then it be added to the selection list in the configuration menu. The earlier "add-on" was just that, an additional set of code to show that it could be possible and how it might be implemented.

[jeking]

Model number won't specifically resolve the issue and is not specific to causing the observed response(s).

Does the store perhaps use products_sku and applied a suggested implementation that was posted earlier in this thread? Basically, if search for EP4_DB_FILTER_KEY to see if it is used outside of the core files in the root of the admin, the extra_functions folder of the admin and/or the admin's modules folder.

Note for others, the plan is/was that if an alternate filter option were desired/to be used, then it be added to the selection list in the configuration menu. The earlier "add-on" was just that, an additional set of code to show that it could be possible and how it might be implemented.

The store does not use EP4_DB_FILTER_KEY nor products_sku. I appreciate the suggestions though. I'll remove them manually again.

[greybeard_it_guy]

Long story behind this, but if I were to import into the products table with product_id that were not consecutive, would that be a problem? In other words, I might import product_id 5442, skip 5443, and then next use 5444.

Would Zen Cart have a problem with these gaps in the product_id?

[mc12345678]

Long story behind this, but if I were to import into the products table with product_id that were not consecutive, would that be a problem? In other words, I might import product_id 5442, skip 5443, and then next use 5444.

Would Zen Cart have a problem with these gaps in the product_id?

My answer is based on say a "fresh" install where numbers are not being "recycled"... no, Zen Cart would not specifically have a problem with numbers not being consecutive.

[mc12345678]

My answer is based on say a "fresh" install where numbers are not being "recycled"... no, Zen Cart would not specifically have a problem with numbers not being consecutive.

I should have added though, remember that the "world" (wide web) "knows" your product by specific products_id.

Note that skipping a products_id is similar to deleting a historic (old) product. Generally speaking ALWAYS skipping a number would in a way effectively reduce the possible number of product in half, but, unless you have more than 49,999,999,999 of the maximum possible 99,999,999,999 products ever to be in the store (not necessarily all at once), this shouldn't be an issue. :)

[delia]

I've just gotten the file ready to import about 40 products. It uploads fine and says it imported okay - no specifics. But the products are not importing. It has been a while since I've done this but what in the world could I be missing? All have product module numbers. I got all fields etc.

[mc12345678]

I've just gotten the file ready to import about 40 products. It uploads fine and says it imported okay - no specifics. But the products are not importing. It has been a while since I've done this but what in the world could I be missing? All have product module numbers. I got all fields etc.

Let's revisit some basics and also get some info...
Version of EP4, is it the latest as published to this forum or from github and what is the reported version for that?
What is the filename for the file?
If looking at the file list for import, is there a reported problem for the delimiter or is the csv delimiter reported as expected? (likely a comma)
What is the setting in the configuration for the import language override.
What "ending" is used for the header of fields that are language dependent such as the v_products_name or v_categories_name?

[keith z]

I use product IDs that are a mix of letters and numbers. Totally not consecutive and have never run into a problem.

[mc12345678]

I use product IDs that are a mix of letters and numbers. Totally not consecutive and have never run into a problem.

Something is not correct about the above statement or the system to which this is applied has been modified as compared to a default install of a standard Zen Cart installation.

In a default Zen Cart installation, a product id is identified in many tables as an integer with up to 11 numbers.

My thought is that the term products ID in the above paragraph is in reference to a product model which is defined as a text (character) string and DOES support a mix of numbers and letters.

If I'm wrong, please let me know.