Discount Table Import

From CommerceV3 Docs

CV3 Documentation Resources
COMMERCEV3 DISCOUNT TABLE IMPORT DOCUMENTATION
Copyright 2008 Color Maria, Inc.,

---

1. TABLE OF CONTENTS

---

1. Table of Contents
2. Introduction
3. Using the Discount Table Import
   I. Overview
   II. Available Fields
4. Appendices
   I. Example Import

---

2. INTRODUCTION

---

The CommerceV3 Discount Table Import allows users to add and update product discount tables via a single spreadsheet.

---

3. USING THE CV3 DISCOUNT TABLE IMPORT

---

3.I OVERVIEW

---

Uploaded import files are pipe- or tab-delimited files that contain discount table information. The file can include any of the possible fields in any order you would like. The only limitations are that the Name and at least one other field must be present. The Name field is used as the key when updating tables. Other than that you can include as many of the fields as you would like to update.

The first line of the import file is the header line. In the header line you will define which fields you will be using. Remember, they can be in any order you would like. The remaining lines will contain discount table data with the information corresponding to the fields you defined in the header line. See below for examples.

---

3.II AVAILABLE FIELDS

---

Note: the "Name" and at least one other field must be included for a successful import

Name                               | required
Description                        | 
RowQty*                           | * represents the value linking row qty, discount, and type
RowDiscount*                       |
RowType*                           | 'amount','percent','new','num'
AdditionalQty                      | 
AdditionalDiscount                 |
AdditionalType                     | 'amount','percent','new'

---

4. Appendices

---

4.I Example Import

---

This is an example import file that includes all available fields.
Download Example Import
Here is a breakdown:

Line 1: Header Line
Line 2: Discount Table Line