How to do specific task with the files in Easy Populate Advance:
1. Adding new products:
a. To add products the product id should be 0, there can be many 0's for product ID's
as needed. The code will detect the 0 as a new product and auto increment the
products_id.
b. If the products_id number is left blank then the product is not added. You can also
insert you own product ID. they do not have to be sequncial.
c. If you need to specify your own unique products_ID, and it does not exist in the data
base it will be added as a new product. Make sure you add the correct categories,
other wise you will need to use the move product to a new category procedure.
Example:
I have a previous inventory software that has already assigned product ID's they are
12001
15001
14
2000
These can be used by simply putting the in the v-product_id column.
2. Adding linked products (Yes Version 3.01 can handle linked products):
A linked product is having one product record set, but having it show in multiple
categories.
a. For a product you want to link to another category
Create a download using complete or model/category in the Select fields to download
you can limit the list by using the filter settings.
b. Import into the spead sheet program.
1. Copy the original product line to a new line
2. Change only category information where you want the product linked to.
Leaving the v_product_id unchanged.
3. Save the file and re upload
3.Deleting products (This has been added back for products only):
a. Single product not linked
Download any of the files that has a products_id's. You will notice a column called v_action
all the way to the left. In this column add delete for each product you which to delete.
b. Deleting linked product:
Do a download that has all of the links for the product
cut the paste th item you which do remove in front of the product links to remain.
In the v_action column enter delete for the link you want to remove.
Note: the deleted item must be listed first. The product to remain must be list after the
product link you are deleting.
4. Moving a product between two categories
In the spread sheet program
1. copy the line for the product to a new line
2. on the original line type in delete in the v_action column
3. on the new line change the categories
4. Removing columns in the spread sheet.
Due to how Ep was designed you do not need all of the column from the export file to be present
in the import file.
1. Minmum columns:
  products_id, v_status, v_action, EOREOR
If you have prodcut information: any or all by products_id can be removed
  If you have mete tags or header tags installed make sure you leave the set together If you have prodcut information: any or all by products_id can be removed
  If you have category information: any or all of the unused category_ columns.
|