Export Product Fields and Combined Category Codes to Flat File
Copyright © 2000, William Weiland
Overview
This module can be used to create a flat file of products and corresponding category codes. This module has been made obsolete with the most recent versions of Merchant as there is a new method for multiple category importing built in. The flat file will be located in your store's data directory. That is the same directory that your products.dbf and products.dbt are in. This module will not include uncategorized products in the flat file. The category codes are in a single field at the end of each product line, separated by the caret ^ character. The other fields are separated with the pipe character. In order to import back into Merchant from this specially constructed export file, you will need to have this file, exprccat.mv (exprccat.mvc compiled) installed in the domain/mall into the modules/export/ directory.
Setup
1) In admin, click Add Modules
2) Click the file upload button
3) Browse to find the exprccat.mv(c) file on your hard drive and upload
4) Click Add to add it to the domain

Editing Requirements
You will have to edit one line in the prodimpt.mv. Locate the line:
<MvDO FILE = "{ g.Module_Library_DB }" NAME = "l.category_id" VALUE = "{ Category_Find_Code( l.category ) }">
Comment that line out or remove it. Replace it with the following line:
<MvDO FILE = "../export/exprccat.mv" NAME = "l.category_id" VALUE = "{Add_to_Category(l.product_id, l.category)}">

If you choose to make this change more permanent (so that it isn't overwritten the next time you update your Merchant version), you should copy the prodimpt.mv file to a new file name. Change the functions in the new file to reflect a different module from the Miva Corp supplied module; ie. Module_Name, Module_Code, and Module_Provider. Then make the one line edit described above in the new file. Then install your new custom import file to the mall.


Usage
1) In admin, click on Stores
2) Click the image to the left of your store name
3) Click the image to the left of Utilities under your store
4) Click the image to the left of Export Data
5) Click on the link to this module
6) Choose a file name to export to