This table describes the different types of import jobs available in the job system. Select the specific import job type via the drop-down in the Extra Settings section.
Job name | Description | Extra settings | Data source/ Mapping notes |
---|---|---|---|
(ASN) Shipping Notification | Imports shipment information associated with waiting
fulfillment shipping orders from an external provider such as
UPS WorldShip or a 3PL. Processing these records create shipments for the associated shipping orders, which are then fulfilled and closed. Note: This job can't be used to
short-ship a shipping order. It automatically assumes that each
Item on a shipping order was included in the
shipment.
|
Specify whether shipping confirmation emails are sent to customers. | The following data is required for each record. See the
Map tab in the job configuration for optional data fields.
|
Bulk Order Import | Imports sales orders. Note: Imported orders are placed in
waiting approval status if order approvals are enabled;
otherwise they are placed in waiting allocation.
|
The following settings are available:
|
The following data is required for each record. See the
Map tab in the job configuration for optional data fields.
|
Catalogs | Imports catalogs. | N/A | The following data is required for each record. See the
Map tab in the job configuration for optional data fields.
|
Categories (Localized) | Imports categories and their general info fields. | N/A | See the Map tab in the job configuration for the data fields. |
Customers | Imports customers. The system checks the customer code of
each record against existing customer records, and update the
existing record if one exists. If there is no customer code
match, it checks for an existing record that matches both the
customer email and last name fields. If there is no matching record, or if there are multiple matching records, then the system creates a new customer record. |
N/A | See the Map tab in the job configuration for the data fields. |
Force Fulfill Import | Imports sales orders and attempts to close them. It will unsuspend, approve, and fulfill orders as needed. Related invoices and payments follow their configured workflow. | The following settings are available:
|
See the Map tab in the job configuration for the data fields. |
Fulfillment Site Quotas | Imports fulfillment site quota information. Allows creating or removing site quotas. | N/A | See the Map tab in the job configuration for the data fields. |
Fulfillment Sites | Imports new or updated site-level information and attributes for one or more sites. | N/A | See the Map tab in the job configuration for the data fields. |
Gift Cards | Imports gift cards. | N/A | See the Map tab in the job configuration for the data fields. |
Item Association | Imports item associations. Can also be used to delete item associations. | Select one of the following modes:
|
See the Map tab in the job configuration for the data
fields. Use the Custom - association_remove
field to delete associations. Importing an association record
with a value of '1' in this column deletes the association if it
exists. |
Item Back Order Authorization | Imports item backorder authorization settings. Can also
be used to delete back order authorizations. Note: Backorder
settings other than the Backorderable flag are not exposed in
the Administration module. They can only be set via this job or
directly in the database.
|
Select one of the following modes:
|
See the Map tab in the job configuration for the complete
list of data fields. Some of the available fields include the
following:
|
Item Catalog | Adds items to catalogs. Can also be used to remove items from catalogs. | Select one of the following modes:
|
See the Map tab in the job configuration for the data
fields. Use the Custom - catalog_remove field
to remove an item from a catalog. Importing an item/ catalog
record with a value of '1' in this column removes the item from
the catalog. |
Item Category | Adds items to categories. Can also be used to remove items from categories. | Select one of the following modes:
|
See the Map tab in the job configuration for the data
fields. Use the Custom - category_remove field
to remove an item from a category. Importing an item/ category
record with a value of '1' in this column removes the item from
the category. |
Item Inventory | Updates item on hand and safety stock inventory levels, including site and location information. Importing multiple files is useful for updating inventory levels at multiple sites. Up to 50 data files matching the filename pattern are imported. | Check the Set On Hand Quantity for Unspecified
Items to 0 to set the on hand quantity to 0 for all
items in the system that are not included in the import data.
See Zero
Inventory Import Option for more information. Note: Use
caution when enabling this feature.
|
Setting the Delta value to 0
causes the imported values to be set as absolute on hand levels
(a value of 10 sets the on hand level to 10, regardless of the
current level). Setting it to one causes the imported values to
be used as deltas (a value of 10 increases the current on hand
level by 10). Note: Safety Stock quantities can only be updated
using absolute values. If the Delta value is one, then any
Safety Stock values in the data are ignored.
See the Map tab in the job configuration for the other data fields. |
Item Photos | Imports hosted photos and associates them with items. Can also be used to disassociate images from items. | Select one of the following modes:
|
Each image must be hosted at a unique URL that is
referenced in the import data. Images can't be embedded directly
in the data. Image URLs can't contain special characters such as
spaces, because the job system won't convert them. The following data is required for each record. See the Map tab in the job configuration for optional data fields.
Custom - image_unlink field to
disassociate an image from an item. Importing an image/ item
record with a value of '1' in this column disassociates the
image from the item. |
Item Price Point | Updates item price points. Can also be used to remove price points from items. | Select one of the following modes:
|
See the Map tab in the job configuration for the data
fields. Price point calc method IDs are as follows:
Price point calc basis IDs are as follows:
Custom - price_point_remove
field to remove a price point from an item. Importing an item/
price point record with a value of '1' in this column will
remove the price point from the item. |
Item Safety Stock![]() |
Updates safety stock quantities for selected items/sites. | N/A | The quantity_safety_stock value is the
safety stock quantity to apply to the specified items at the
appropriate sitesYou must specify either
The If multiple fields are specified, then only items/sites matching all of them are affected. |
Item Vendor | Updates item vendor associations. Can also be used to remove a vendor association. | Select one of the following modes:
|
See the Map tab in the job configuration for the data
fields. Use the Custom - vendor_remove field to
disassociate a vendor from an item. Importing an item/ vendor
record with a value of '1' in this column will disassociate the
vendor from the item. |
Items | Imports new items and updates fields and attributes on
existing items. Note: Imported attributes must exist in the
system. This job won't create new attributes.
Note: When
importing master and child items, a master Item must exist
before its child Items can be imported. If they are in the same
import data file, then the master Item must appear before the
child items. When importing a master item, the master item code
field must be NULL.
|
N/A | See the Map tab in the job configuration for the data
fields. Note the following when importing items:
|
Items (Localized) | Imports localized values for item fields that can be localized. The items must already exist, because this job only imports values for localizable fields. | N/A | See the Map tab in the job configuration for the data fields. |
Postal Codes | Imports postal codes. | Select one of the following modes:
|
The following data is required for each record. See the
Map tab in the Job configuration for optional data
fields. Note: Many postal codes include leading zeroes. Be
careful to preserve them when generating input files.
|
Promotion Codes | Imports promotion codes. | N/A | The following data is required for each record. See the
Map tab in the job configuration for optional data fields.
|
Purchase Order Advice Notification | Imports purchase order information associated with
received shipments from vendors. Processing these records will update purchase orders with received quantities. If all items on a purchase order have been received, the purchase order will proceed to the next workflow step and close if appropriate. |
N/A | See the Map tab in the job configuration for the data fields. |
Serialized Items | Imports additional quantities of existing serialized items. | N/A | See the Map tab in the job configuration for the data fields. |
Tax Table | Imports a tax rate table. Can also be used to delete a tax rate table. | N/A | See the Map tab in the job configuration for the data
fields. Use the Custom - tax_remove field to
delete a tax rate table. Importing a tax rate table record with
a value of '1' in this column deletes the tax rate table if it
exists. |
Vendors | Imports vendor records. | N/A | See the Map tab in the job configuration for the data fields. |