EasyPopulate 4.0 Support Thread

[MCS_Computers]

I have just upgrades to EP4 and having 1 issue and I`m sure it is something I`ve missed.

My main categories are INKJET / TONERS / SOLID INK / RIBBONS / DRUMS etc

When these are clicked inside each are ADVENT / BROTHER / CANON / DELL / EPSON etc

When using the earlier version this was working okay, since the upgrade I still have the main categories however there are no sub categories so all INKJET are all together.

I have checked to make sure the CSV headings are correct so I`m baffled.

Any advice muchly appreciated as it always is.

Mike Smith

[mc12345678]

I have just upgrades to EP4 and having 1 issue and I`m sure it is something I`ve missed.

My main categories are INKJET / TONERS / SOLID INK / RIBBONS / DRUMS etc

When these are clicked inside each are ADVENT / BROTHER / CANON / DELL / EPSON etc

When using the earlier version this was working okay, since the upgrade I still have the main categories however there are no sub categories so all INKJET are all together.

I have checked to make sure the CSV headings are correct so I`m baffled.

Any advice muchly appreciated as it always is.

Mike Smith

Take a look at the export of a file related to a category that either has or is a sub-category and also the instructions, both of which would identify that sub-categories are identified by using the carat symbol (^) as the divider between each such sub-category.

[MCS_Computers]

I used the EP to download a Model/Category and it said Inkjet^Advent as I had only imported the advent CSV file but through the store Inkjet had no sub categories. Sorry if that's not what you meant, you`ve helped a lot over the last few days so you should know that I'm a beginner, this is my last hurdle.

[mc12345678]

I used the EP to download a Model/Category and it said Inkjet^Advent as I had only imported the advent CSV file but through the store Inkjet had no sub categories. Sorry if that's not what you meant, you`ve helped a lot over the last few days so you should know that I'm a beginner, this is my last hurdle.

In a way that's what I meant, if I understand correctly. (which I'm not entirely sure that I do.)

My thoughts were this. If you already have at least one category that is a sub-category (preferably "manually" generated groups), then export of product (active or all) for that category (or sub-category) using the dropdowns across the top of the EP4 tools/admin screen would reflect the information/way that EP4 would expect the data to be made available to reproduce the same type/style of a product.

Mind you, again, the file generated is UTF-8 and the file normally expected for upload followed by import should also be in UTF-8 format. Further, the expectation is that if you look at the raw csv file using a plain text editor both before and after editing, they should look relatively similar. EP4 does add some extra double quotes (" not ') around information, that at least when using Open Office tend not to be "put back", but that's not necessarily an issue.

Anyways, I don't want to overload, especially if the first couple of things above address the issue (again, assuming I understand correctly)

[MCS_Computers]

It has to be a EP4 thing because my previous version imports the CSV and the store shows category and sub categories as it should

[mc12345678]

It has to be a EP4 thing because my previous version imports the CSV and the store shows category and sub categories as it should

Umm. The proof of the "EP4" thing would be to export the file, then do nothing with it but upload and then import it again. The result should be no change to the site.

Then considering that the upload/import of an untouched file works, the next thing is to modify something about the file and repeat the upload/import. The only thing that should change is what was modified.

EP4 works to generate new categories as well as to add product to existing/new categories. If it doesn't for the particular site, then we need to start talking about information that is provided on the EP4 screen to see what isn't correctly setup, the configuration settings, and/or the details of generating the modified csv file.

If need be, PM me login details.

[MCS_Computers]

MC thanks yet again you pointed me in the direction to fix it.

In the older version of EP it created 2 columns, v_categories_name_1 and v_categories_name_2

1 had Inkjet in and 2 had Advent in, I deleted the 2 column and changed 1 from Inkjet to Inkjet^Advent, re imported the CSV and it worked a treat.

Many thanks once again buddy, it is much appreciated..

[mc12345678]

MC thanks yet again you pointed me in the direction to fix it.

In the older version of EP it created 2 columns, v_categories_name_1 and v_categories_name_2

1 had Inkjet in and 2 had Advent in, I deleted the 2 column and changed 1 from Inkjet to Inkjet^Advent, re imported the CSV and it worked a treat.

Many thanks once again buddy, it is much appreciated..

As discussed in one of the other threads, EP4 uses that number to correspond to a language. Yes, it's a little bit of a puzzle and I've been wanting to change the number to a language, but there were other more important fixes to apply over time. At any rate, if you go multi-language, then you can use EP4 to populate the associated language fields using the applicable v_FIELD_LANGUAGEID. Where FIELD might be something like products_description, category, etc... LANGUAGEID would be the number next to the language that you see on the right side of the EP4 tools screen.

[Feznizzle]

I'm in the process of building a catalog with about 25,000 products. Even when the data is segmented into groups of 5,000 products, my spreadsheet (libreoffice) bogs down when all data is present (particularly the html for product description pages).

To make this manageable, I want to upload/insert in stages. First I'll CREATE products by inserting bare minimum info (model, ID, Category, Prod name, qty, status, order units, etc). After that, I'll come back and UPDATE those products by inserting additional data (image, price, description, etc).

The following questions are about working with product files (eg, Full-EP2017Sep26-165412.csv).

Product page creation questions:
1. When creating NEW product pages, can I leave the following columns blank (no data)?
v_products_description_1
v_products_price
v_products_weight
v_date_avail
v_date_added

If not, I'll insert small dummy info to replace during later updates.

2. When creating NEW product pages, can I *delete* columns I don't need at the moment (meta data, specials, etc) to reduce clutter? Or does EP4 freak out if columns it expects don't exist?

Updating product page questions:
3. When updating EXISTING product pages, can I *delete* columns I don't wish to change (category, product name) to reduce clutter? Obviously I'll keep the important ones (model, ID, etc).

4. If I have to keep all columns, can I leave the ones I don't wish to change blank?