EasyPopulate 4.0 Support Thread

[wheat]

When you want to MOVE ALL products to a new category - this is what works for me.

I would try it with a category that has very few products (and even do as practice
because there is nothing more tedious that removing items ONE by @#$@%# One
and besides, what does a former blonde know "for sure"

Use EZPop to download the category you are "closing out"
I like to save it to the desktop with a name that will remind what it is "just in case" you need to put stuff back
much less taxing than a full back up

after that, you are using other functions of Zen

Make a note of the old category NUMBER - this will correspond to the number 8 in the explanation

Create new Category & note that number as well - this will correspond to the 22 in the explanation

select any product that you want in the new category

Click on the C for copy

from the copy menu on your right
scroll down and select

Multiple Categories Link Manager

Scroll donw to
Global Category Link Changes and Master Category ID Reset

Using the first function: Copy ALL Products in a category as linked...
Enter Old Category Number (and I really wish that word was there )
In the box next to "Select All Products in Category"

Enter NEW Category Number in the "Link to Category"

Click" copy products as Linked
(note it would be REALLY Nice to be able to Copy products as Duplicates

Next, (third function down) Enter the NEW category number
in the box:
Reset the Master Categories ID for All Products in Category:
Click: Reset Master...

Finally ( and this is where I usually manage to screw up)

Middle function:
Remove ALL Products in a Category that are LINKED....
Enter OLD number in Select All Products in Categoy
enter NEW number in Remove from being linked

Now check your work in case I (as I often might) have the placement of old and new confused.

[Blenderite]

If I want to adjust a column in the data base which is not exported by default (for example the column STOCK_LIMITED) can I include a header for it in the CSV file and import or do I need to add that somewhere in the code?

[mc12345678]

If I want to adjust a column in the data base which is not exported by default (for example the column STOCK_LIMITED) can I include a header for it in the CSV file and import or do I need to add that somewhere in the code?

If the field (column) STOCK_LIMITED is in the products table, then it is easily included by entering the field in the custom_fields option under configuration->Easy Populate 4 and it will be included in applicable exports and imports.

[mc12345678]

Further, if don't know the location of the field in the database, there is no harm in adding the field in the user defined option and then exporting the full products option. If the field appears, then it is in the products table, if not then more "investigation" is necessary. When entering the field name, enter it as it appears in the database table (typically without v_)

[lruskauff]

If I want to adjust a column in the data base which is not exported by default (for example the column STOCK_LIMITED) can I include a header for it in the CSV file and import or do I need to add that somewhere in the code?

You also need to enter it in the admin under configuration->ep4
Enter any extra fields as user defined.