Product Zones CSV Format

This type of import enables you to specify the zones to which your product exceptions apply. Product Zones import files apply only to existing products: those you created in Determination, or those you uploaded with the Import/Export Wizard.

For information about using CSV format files, see Best Practices for Importing Data with CSV Files.

US and Non-US Product Zones Files

The sdiType value changes depending on whether the file contains US zones or Non-US zones.

  • For US zones, use sdiType=ProductZones-US.
  • For non-US zones, use sdiType=ProductZones-INTL.

In both cases, the file format is the same; only the valid values in the ZoneName column are different.

Product Zones File Format

SDITYPE=ProductZones-US or ProductZones-INTL

Column Name

Format

Req?

Description

ProductPath

varchar2(100) (See Description)

Y

The full path of an existing product category in dot notation (parent.child.childs-child). Note that the length of 100 refers to an individual level of the path, not the entire path length.

ZoneName

varchar2(100)

Y

A zone to which the product exception applies.

  • For US imports, a state.
  • For non-US imports, a Country. EU countries must be prefaced with EU.; for example, EU.FRANCE.

Multiple zones can be specified by submitting multiple lines in the input file. See the example below for more information.

StartDate

mm/dd/yyyy

Y

A start date for the exception in this zone.

EndDate

mm/dd/yyyy

N

An optional end date for the exception in this zone.

Exempt

varchar2(1)

Y

If set to Y, indicates exemption in this zone during the specified start/end date period. If blank, defaults to N.

OverrideLocals

varchar2(1)

N

If set to Y, indicates that the Zone level exemption setting overrides any Authority level exemptions set for this Product/Zone combination. Authority level exemptions must be set in Determination.

The ProductPath delimiter is a dot (.) by default. This delimiter can be changed to another supported character by setting the SDI_HIERARCHY_DELIMETER Configuration parameter using Determination. See the Help or User's Guide for more information.

Example Product Zones File

This file creates multiple product zone records for a single product category. Note that the EndDate column is omitted as these product exceptions do not expire.

  1. sdiType=ProductZones-US

  2. ProductPath,ZoneName,StartDate,Exempt,OverrideLocals

  3. Office Supplies.Paper,WASHINGTON,03/05/2005,Y,Y

  4. Office Supplies.Paper,IDAHO,03/05/2005,Y,N

  5. Office Supplies.Paper,CALIFORNIA,03/05/2005,N,N

For more information about formatting a CSV file, see Creating CSV Import Files.

Updating a Product Zone Record

You can update a product zone record by including ProductPath, ZoneName, CustomProduct, and StartDate data to match an existing record and then updating the other columns as desired.

Product Zones Import Prerequisites

You need to import or create any desired product categories on the target system before importing product zone data with the Import/Export Wizard.

Product Zones Import Options

When you import product zone data, the Import/Export Wizard prompts for:

  • Company Selection: Select the desired company.
  • Product Group Selection: Select the desired Product Group.