Copyright © 2000, William Weiland
Used to import the quantity of each product from a flat file.
1) In admin, click Add Modules link (fig 2)
2) Click the file upload button
3) Browse to find the prodquan.mvc file on your hard drive and upload (fig 3)
4) Click Add to add it to the domain
5) In admin, click Add Modules link (fig 2)
6) Click the file upload button
7) Browse to find the prdquanx.mvc file on your hard drive and upload (fig 3)
8) Click Add to add it to the domain
9) 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 plus to the left of the word Utilities under the store. Then click on the plus for Export Data. Then click on the link for Export Product Quantities to Flat File. The prompt will ask for the flat file name. Only put the file name, no path, e.g. prodquan.txt
Import: Click on the plus to the left of the word Utilities under the store. Then click on the plus 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.
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. Name the flat file prodquan.txt.
Format the Flat File
For Example:
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.
Only two elements are on each line for each product linkage. They are the
product code and quantity, separated by the | delimiter. For readability,
you can have a third element, the product code. The last product in the
example belows shows how that optional entry would look.
1AA00001|934
1AA00002|964
1AA00003|X
1AA00004|896
1AA00005|234|Example Product Name
