1. Adding new products:
(These procedures are for EPA only)
a. Because
EPA uses the product_ID to link to your products in the database and EPB still
uses model numbers many of the additional features for EPA cannot be added to
EPB. EPB is used for backward compatibly to older versions of EP.
b. 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.
c. 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 sequential.
d. 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.
e. A Product_id must be a number, this is done so the admin
products edit/add for will work.
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 spread 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 the 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. Move a product
to a new category:
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
5. Reducing size of
import file
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. Minimum columns:
a. products_id, v_status, v_action, EOREOR
If you have product information: any or all by products_id can be removed
b. If you have meta tags or header tags installed make sure you leave the set together If you have product information: any or all by products_id's can be removed
c. If you have category information: any or all of the unused category_ columns.
2. Caution: EP reads a product record set from you data base, then merges data
from the import file. If the column you removed from the export file is
not in this beginning query then that column will be removed from the data base.
Example: previously if you removed one of the ultra images fields it would
delete all data from that column in the products database. Not this bug
has been fixed for ultra images, but it is something to keep in mind when constructing
new export files.
6. Your first import file
a. When you first start to load a store with products it is usually easier to
set up you category structure in the admin before you begin
b.
Back up your data base!!!!.
c. Export a complete download so you have all of the headers in the export file.
d. Start your spread sheet program and click on the open file.
e. Navigate to the directory on your local computer where the export file resides. Make
sure you change the file type, in the open file dialog to "text CVS,txt". If you do not all of the information in the
text file will be read into one cell of the spreadsheet program.
f. Single (') and double quotes (") , MYSQL has problem when you try to insert reserved characters.
I can cause error when trying to import then into your database. There are two ways to
handle these
1. Escape the character Example: There\'s Something About Mary
2. Use decimal equivalent of the character Example: There's Something About Mary
EPA and EPB can read both of these and correctly inserts the MYSQL compatible character
so single and double quotes are displayed correctly in the catalog. Even if
you choose not to use either of these methods EPA and EPB will read the single
and double quotes and convert then as needed.
g. Product descriptions: You can draft these with an external HTML
editing program or word processor, but you must be careful which one you use.
Most MS products used proprietary formats that may not be compatible
with most web browsers in use today.
h. When you save the spread
sheet file the first time use the save as function instead of the save function.
change the name to something different, in the file type make sure it is "text CVS,txt".
This will preserve the original file in case you already had product in it. This
is done so that you can recover form possible errors.
i.
For new products use the product use the product_id of 0 if you wish the cart
to set you product id's or entry and number op to 15 digits you want.
j.
Do one final save making sure the file type is "text CVS,txt"., then
go to your cart in import the file.