Dyntex Hosting - Manuals: Miva Order User's Guide

Miva Order 1.15 User Manual 21 5 - Importing Products from Flat Files those found in the records of the import file will be overwritten with the new
information from the imported records. Null entries in any fields will overwrite
fields on the form, which contain data. Update The Existing Products
Slightly different from replacement is updating. Where selected fields in selected
product records need updating with new information, and all other information in
the g iven record needs to be left untouched and intact, u se the update option.
For example, your order form has 20 different product records, and the price fields
in records 1, 5, 12, and 17 need updating. In such a case select the ‘Update’
option, and in the form that follows you’ll be able to choose from which of the fields
in your import file you want Miva Order to get its new data for price. All the records
that perfectly match those being imported (2 through 4, 6 through 11, 13 through
16, and 18 through 20) will be left untouched.
All of the records on the form with information (in the specified fields) that differs
from information in matching imported records will be overwritten with the new
imported information. The form also displays a table of the first 5 records in your import file (the
example shows a flat file with only two products). A drop-down select list of the
different Miva Order product record fields allows you to assign your data to these
fields .
As you can see, the sequential order of the fields in your import file has no bearing
on that of the product records on your order form. This is because you have the
power to tell ‘Import Utility’ exactly “what” to grab “where,” as well as “what to call
it” and “where to put it.”
Be sure that when designating one or more fields in your import file for writing to
product records in your store you first designate the field that contains ‘Product
Code’ because that is what Miva Order will use to find the correct records to
update. All extra fields in your import file that contain information not assigned will
be ignored. Only the information in the fields that you designate will be imported.

Return to Table of Contents		Go to Top of Page
MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal
iDeveloperNetwork - software development services

Copyright © 2002 Dyntex Group, Inc. All Rights Reserved


Return to Table of Contents



Chapter 5: Importing Products from Flat Files		Delete a Batch Chapter 7: Payment Gateways Preliminary Tasks Anacom Payment Services Authorize.Net Payment Services v3.0 Cardservice International (LinkPoint API) CyberCash Cybersource ICS2 Payflow Pro (Signio)
Importing Products Add product File Upload Product Flat File Importing Your Product Information Update The Existing Products - p.1 Update The Existing Products - p.2 Chapter 6: Order Processing View/Edit an Order Create a Batch