Product Quantity Import
Copyright © 2000, William Weiland
Overview
Used to import the quantity of each product from a flat file.
Initial Setup and Usage
Use the Merchant admin upload feature (admin:modules:add module) to upload the module prodquan.mv (prodquan.mvc compiled). After uploaded, click the Add button to add it to the mall/domain.

Import modules automatically reside in each store within a domain so there is no need to assign it to the store.

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 Product Quantity Import. The prompt will ask for the flat file name. Only put the file name (prodquan.txt), no path.


Understanding the Flat File Format
The data elements 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
Create the flat file and FTP it to the data directory under your store. It will be the same directory that your products.dbf and products.dbt are in. Name the flat file prodquan.txt.

Format the Flat File
Only two elements are on each line for each product linkage. They are the product code and quantity, separated by the | delimiter.

For Example:
1AA00001|934
1AA00002|964
1AA00003|X
1AA00004|896

Leave the last line of prodquan.txt blank.

Note the X for the quantity of the third product. Use an X if you want the quantity to be zero for that product.

If you are having time-out problems with importing, you may need break up your flat file into smaller flat files.