EasyPopulate 4.0 Support Thread

While I did not go line for line through the entire list, the four items are correct and the rest look correct.

mc12345678:

So, in order to do such a database to database transfer . . .
I think there is a misunderstanding of what I'm trying to accomplish. I am trying to learn how to take a set of products/categories (including their detailed attributes info) from one store and add them to another store. So, as a first step in learning how to do this, for simplicity I tried in the above example to just go ahead and import all the products/categories including their detailed attributes and I failed.

So, maybe it is less confusing if I ask the direct question . . .

What is the procedure for getting a set of products including their detailed attributes from one store into another store?

Zean:

I think there is a misunderstanding of what I'm trying to accomplish. I am trying to learn how to take a set of products/categories (including their detailed attributes info) from one store and add them to another store. So, as a first step in learning how to do this, for simplicity I tried in the above example to just go ahead and import all the products/categories including their detailed attributes and I failed.

So, maybe it is less confusing if I ask the direct question . . .

What is the procedure for getting a set of products including their detailed attributes from one store into another store?

Export the database of the old store (phpmyadmin), import the database into a new/equivalent (not older) store, upload zc_install for the version of the destination store. Access the new store using zc_install on the path, provide the admin credentials of the old store. Select database upgrade. That is the basic "upgrade" ones site instruction that is probably better described here.

If the other additional information is not desired, then would still suggest a similar process but use an intermediate "site" on which to upgrade the database, then to export the applicable product table data (multiple tables) and import to the new store (replacing existing content).

Otherwise up to the point of detailing the attributes with the extra data, EP4 at least carries over the "basics" of the product when trying to do such a move. The last step requires a bit of shuffling.

mc12345678:

If the other additional information is not desired, then would still suggest a similar process but use an intermediate "site" on which to upgrade the database, then to export the applicable product table data (multiple tables) and import to the new store (replacing existing content).

Thank you. I apologize for not being clearer, but please allow me to continue to try. I asked, "What is the procedure for getting a set of products including their detailed attributes from one store into another store?"

To further clarify, they are both existing stores and both have existing products. So, I do not want to "replace existing content" nor destroy any content in the 2nd store. For clarity, let's call that store, "Store 2" instead of "new store," since it is not a new store.

Definitions -
Store 1 is the store with the desirable subset of products (many of which have attributes). I think of it as the "Donor store."
Store 2 is the store that wants to sell a subset of Store 1's products. I think of it as the "Recipient store."

What is the procedure for getting the set of products including their detailed attributes from Store 1 into another Store 2?

Zean:

Thank you. I apologize for not being clearer, but please allow me to continue to try. I asked, "What is the procedure for getting a set of products including their detailed attributes from one store into another store?"

To further clarify, they are both existing stores and both have existing products. So, I do not want to "replace existing content" nor destroy any content in the 2nd store. For clarity, let's call that store, "Store 2" instead of "new store," since it is not a new store.

Definitions -
Store 1 is the store with the desirable subset of products (many of which have attributes). I think of it as the "Donor store."
Store 2 is the store that wants to sell a subset of Store 1's products. I think of it as the "Recipient store."

What is the procedure for getting the set of products including their detailed attributes from Store 1 into another Store 2?

So, I'm going to stick with describing how one could do this with EP4 at the moment. Another method that comes to mind would be to "simply" export the various attributes related tables and make changes to them to match up with what is available in store 2 and then import the new/revised data. Not what I would consider a quick task.

Regarding EP4. If store 1 has a unique model # for each product and the option names are unique (only one instance of the option name in all of the option names), then the import of the first two files has populated store 2 with all of the attributes of the product from store 1. What is missing though is the detail associated with each attribute. So, to update store 2's attribute details, a file has to be generated such that each of the four primary keys match an existing entry in the attributes table. So, how to accomplish this?

Here's what I see. It is possible at this point to export the detailed attributes from both store 1 (already have) and store 2. Each of these has text versions of the option names and option values names. The model number is whatever it is and the products_attributes_id is expected to be unique to each store.

So what I would do would be to sort the data in both detailed lists on three fields in the same "order" (either ascending or descending but make it the same on both spreadsheets) such that sorted by products_model, then option_name, and then option_value_name.
Then pick the method/location desired, but the goal is to eliminate from the list for store 2 any product that is not in store 1. This would be by a comparison of products_model. For now, also eliminate from store 1 any row that doesn't have a model #. (will have to address that separately because really that product never got uploaded to store 2, but at least the list should be small.)
Then begin moving entire rows as necessary such that the row in store 1 lines up with the row of store 2 by first comparing option names then option value names. Provided nothing "new" has been done with store 2, these should line up exactly.
Then once all have been lined up, copy the primary field data from store 2 over the data of the same field for store 1. Once all four columns are copied, save the file as the csv file to be uploaded and then imported into store 2.

Obviously through this process you'll want to save a backup of the file(s) to minimize any rework. Keep in mind the filenaming convention needed by the plugin.

And with that, the new file when uploaded and imported to store 2 should have store 2 with the same attributes and details of attributes as store 1.

mc12345678:

And with that, the new file when uploaded and imported to store 2 should have store 2 with the same attributes and details of attributes as store 1.
Indeed! It worked! I would like to send a little love in the form of Bitcoin. Please let me know when you have a Bitcoin account so I can send it.
Thanks!

Zean:

Indeed! It worked! I would like to send a little love in the form of Bitcoin. Please let me know when you have a Bitcoin account so I can send it.
Thanks!

Will do. And FYI I started an issue on github to try to do this programmatically when a detailed import fails so completely. Error handling will be interesting. :p considering as the file is parsed the error(s) are generated. The thought though is that if they don't work out in the end to go back and follow the above process "internally".

How do we get EP4 to export, import and update the sort order for categories, products and attributes display?
EP4 is already exporting, importing and updating these items but just isn't including the various sort order fields.
Please see attached spreadsheet which organizes the problem by showing the Zen Cart database fields that should be included in EP4 export, import and updating.
This is an extension of, What is the procedure for getting the set of products including their detailed attributes from Store 1 into another Store 2?

Zean:

How do we get EP4 to export, import and update the sort order for categories, products and attributes display?
EP4 is already exporting, importing and updating these
items but just isn't including the various sort order fields.
Please see attached spreadsheet which organizes the problem by showing the Zen Cart database fields that should be included in EP4 export, import and updating.
This is an extension of, What is the procedure for getting the set of products including their detailed attributes from Store 1 into another Store 2?

For categories, you would need to use the category related downloads which are not in your list of the spreadsheet.

For attributes, ultimately should state please revisit the instructions, but the sort order at least for option values is in a series of 10 value increments for each individual option value added to the option name. I also see in the import code that there are several sort order import fields that are available for the above orders of concern. The products_attributes sort order is primarily important for the store front as it is the sort order applied there that will determine how ZC default attribute handling is controlled when sort order is applied.

This is conceptually trivial. I just want EP4 to include all the SORT ORDER fields which are associated with some of the fields EP4 is already including. That's it.

Let's review.
EP4 exports, imports and updates certain data related to categories, products and attributes. However,
EP4 DOES NOT export and/or import and/or update the complete set of SORT ORDER fields for categories, products and attributes which control the display sort order of categories, products and attributes in the Zen Cart store.

1. Using EP4 "Filterable Exports:" "Download Type" of "Complete Product" EP4 exports a Full-EPyyyymmmdd-tttttt.csv file.
   Among the fields (columns) that are exported is v_categories_name_1
   Unfortunately (and mysteriously) the SORT ORDER field associated with v_categories_name_1 (i.e., categories.sort_order) is not exported. Therefore, I want it to be exported so when I use EP4 "input" "full data file" the sort order field associated with v_categories_name_1 is also imported.

2. Using "Attribute Export/Import Options" "Basic Products Attributes (basic single-line)" EP4 exports an Attrib-Basic-EPyyyymmmdd-tttttt.csv file.

Among the fields (columns) exported are v_products_options_type, v_products_options_name_1, and v_products_options_values_name_1
Unfortunately, and mysteriously, the SORT ORDER field associated with these 3 fields (i.e., products_options.products_options_sort_order, products_options_values.products_options_values_sort_order, and products_options.products_options_sort_order) are not exported. Therefore, I want them to be exported so when I use EP4 "input" "attrib-basic-ep" the sort order field associated with v_products_options_type, v_products_options_name_1, and v_products_options_values_name_1 are also imported.

3. Using "Attribute Export/Import Options" "Detailed Products Attributes (detailed multi-line)" EP4 exports an Attrib-Detailed-EPyyyymmmdd-tttttt.csv file.

Among the fields (columns) exported are v_products_options_type, v_products_options_name, and v_products_options_values_name
Unfortunately, and mysteriously, the SORT ORDER field associated with these 3 fields are not exported. Therefore, I want them to be exported so when I use EP4 "input" "attrib-detailed-ep" their associated sort order fields are also imported.
Note: Interestingly, EP4 does export the sort order for products_options (i.e., v_products_options_sort_order) but,mysteriously, not the other sort order fields.

I thought I would just add the SORT ORDER fields to the various areas areas of EP4 code in files:

1. easypopulate_4_export.php
2. easypopulate_4_filelayout.php
3. easypopulate_4_attrib.php
4. easypopulate_4_import.php

Alas, I can't figure out how to do it. So I'm going to have to give up on EP4 unless someone comes to the rescue.

Zean:

How do we get EP4 to export, import and update the sort order for categories, products and attributes display?
EP4 is already exporting, importing and updating these items but just isn't including the various sort order fields.
Please see attached spreadsheet which organizes the problem by showing the Zen Cart database fields that should be included in EP4 export, import and updating.
This is an extension of, What is the procedure for getting the set of products including their detailed attributes from Store 1 into another Store 2?

zencart version 155a

getting this error

An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

how to solve?

What was being performed?

Version of EP4?

Source of file if occurred during import? (was this an import of a file that was exported but not modified? If modified, with what?)

Is there a debug.txt file in your list of files? What are it's contents (shouldn't have any admin information nor specific database credentials.)

Here is the info

The error file says

[12-Jun-2016 07:11:19 Europe/Berlin] Request URI: /zencart/framecraft/newsite/w4reh0use/easypopulate_4.php, IP address: ::1
#1 mysqli_num_rows() called at [D:\xampp\htdocs\zencart\framecraft\newsite\w4reh0use\includes\functions\extra_functions\easypopulate_4_functions.php:84]
#2 ep_4_SBA1Exists() called at [D:\xampp\htdocs\zencart\framecraft\newsite\w4reh0use\easypopulate_4.php:272]

[12-Jun-2016 07:11:19 Europe/Berlin] PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in D:\xampp\htdocs\zencart\framecraft\newsite\w4reh0use\includes\functions\extra_functions\easypopulate_4_functions.php on line 84

ITS A FRESH INSTALL IN ZENCART 155a

diptimoy:

Here is the info

The error file says

[12-Jun-2016 07:11:19 Europe/Berlin] Request URI: /zencart/framecraft/newsite/w4reh0use/easypopulate_4.php, IP address: ::1
#1 mysqli_num_rows() called at [D:\xampp\htdocs\zencart\framecraft\newsite\w4reh0use\includes\functions\extra_functions\easypopulate_4_functions.php:84]
#2 ep_4_SBA1Exists() called at [D:\xampp\htdocs\zencart\framecraft\newsite\w4reh0use\easypopulate_4.php:272]

[12-Jun-2016 07:11:19 Europe/Berlin] PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in D:\xampp\htdocs\zencart\framecraft\newsite\w4reh0use\includes\functions\extra_functions\easypopulate_4_functions.php on line 84

ITS A FRESH INSTALL IN ZENCART 155a

It looks like at one time you have installed Stock-By-Attributes and then emptied the table but didn't delete the table. If you don't run SBA, then may I suggest the following SQL to be put into the tools->install SQL patches text box.

drop table products_with_attributes_stock

Also, may I suggest that you rename your admin folder as it has now been posted for all to see, read, or navigate.

Thanks for early reply , stock by attributes needed

the admin name is for my local machine , online its different anyway will take care of

diptimoy:

Thanks for early reply , stock by attributes needed

the admin name is for my local machine , online its different anyway will take care of

Say needed, but (and mostly to verify that tests capture the correct information) is it installed, and if so is there any data yet entered and associated?

mc12345678:

Say needed, but (and mostly to verify that tests capture the correct information) is it installed, and if so is there any data yet entered and associated?

Thank's for all , the issue solved . yes its the sba , uninstall and reinstall did the work

Hello, my question is this, but if I want to add products to existing ones, there is a blank template in order to submit the new products? and the id of these products as are placed, in succession to the existing ones? Thank you

giancalr:

Hello, my question is this, but if I want to add products to existing ones, there is a blank template in order to submit the new products? and the id of these products as are placed, in succession to the existing ones? Thank you
The best template is to create one from your own store. Export the full store for example and you can see what information is used to describe your product.

As to the products_id and numbering. If you use the model# then yes the products_id is expected to be the next available products_id basically using the database tables definition of what is next. (autogenerated number) if you use products_id as your unique identifier, then autogeneration only occurs when the selection of blank_new is made in the configuration window and the field is left blank on import. Otherwise the product will take the products_id that is assigned for that row.

It is relatively versatile and has many ways to accomplish the desired task even if there are a few things still on which to improve.

zc1.5.5a upgraded site hosted on a CentOS 6.7 server running php5.3.3
EP4 Config and import error screenshots attached
EasyPopulate-4.0-4.0.35.ZC acquired from github here
https://github.com/chaddro/EasyPopulate-4.0

exported complete products csv for template Full-EP2016Jun13-1301.csv
confirmed categories exist
confirmed syntax for category^subcategory
confirmed date syntax
not using SBA
created single product csv for import ClassesForEveryone.csv
getting errors for character limit of category and sub category on import
tried increasing character limit for these fields in MySQL as suggested in earlier posts from this thread. I still get error like op.
category name and sub category names character count does not exceed limits but I still get error and import fails
What am I missing?

Should this version of EP4 work with zc1.5.5a? If not is there a roadmap for when it will? And or is there a version of EP4 that is known to work with a specific version of ZC1.5x?

Thank you for your hard work on this mod. My client who owns this shop had been using 1.2.5.7 in zc1.3.9h for many years without issue.