Copyright © 2001, William Weiland
Import Related Product linkage into your Merchant store directly from a flat file.
Use the Merchant admin upload feature to upload the modules relprdim.mv and relprdex.mv. As each are uploaded, click the Add button to add them to the mall/domain.
Import and Export modules automatically reside in each store within a domain so there is no need to update them to the store.
Export: Click on the image to the left of the word Utilities under the store. Then click on the image for Export Data. Then click on the link for Related Product Export. The prompt will ask for the flat file name. Only put the file name, no path. For example, relprdim.dat
Import: Click on the image to the left of the word Utilities under the store. Then click on the image for Import Data. Then click on the link for Related Product Import. The prompt will ask for the flat file name. Only put the file name, no path.
Headstart
If your store already has related products associated with your
products, use the export module (relprdex.mv) to create a flat file in the
proper format. This can also serve as a backup (archive) copy of your
related products linkage. The default name of the export file is
relprdim.dat. Keep a copy off-line along with your other backup copies
of data.
The data elements which comprise the related products links are pulled from the flat file in a specific order. Since there is no artificial intelligence involved in this flat file import, it is imperative that the data be placed in a flat file in the same order that the program expects it to be. Any variance from that is likely to result in corrupt data in your database.
Creating the Flat File
If you are starting from scratch and have no related products in
your store yet, you can create the flat file in your text editor. Create
the flat file and put it in the data directory under your store. It
will be the same directory that your products.dbf and products.dbt are in.
The default name should be relprdim.dat.
Format the Flat File
For Example:
When importing, be sure that the last line of the flat file is a blank line.
When you import, each product code is checked to see if each product exists
and if the related product linkage already exist with that product code.
Thus only valid codes are linked and duplication of links is avoided.
If you are having time-out problems with importing, you may need break up
your flat file into smaller flat files.
I highly recommend adding only a couple related product links in the flat file until
you are sure you thoroughly understand the flat file format. Since a
related product export module is supplied with this system, it would
be best if you export your existing related product links to a flat file
before you add any. Then you can study that file for proper format.
Only two elements are on each line for each product linkage. They are the
primary product code and the product code that is to be linked to the
primary.
ABC123|XYZ123
ABC123|XYZ456
ABC456|CPC123