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.


Quote Originally Posted by Zean View Post
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?


Click image for larger version. 

Name:	Capture.jpg 
Views:	617 
Size:	63.7 KB 
ID:	16399