Understanding Import and Export Fields

Follow

Importing large amounts of data at one time can sometimes be extremely useful and frustrating at the same time. The key to successfully importing data correctly is understanding what each column means. This links below will provide you with a brief explanation of what each column represents for the various types of imports and exports.

Product Import/Exports

Customer Import/Exports

Product Variant Inventory Import/Export

Category Import/Export

Product Pricing Import/Export

 

*NOTE:* Some formatting may change depending on the spreadsheet software you use to open your .CSV file. Ex. a SKU of "6-2" will be formatted as "2-Jun" by Excel.

 

Product Import/Exports

ItemID - This is the number that is created and assigned by the system when a product is first created or imported. This number is predominantly used as an identifier for each specific product in the database. We recommend that this number is never changed and is always included in your imports.

ItemNumber - This is the item number that you set for each of your products. Most often referred to as Item “Number (SKU)”, this number can be changed or modified at your discretion.

ItemName - This is the name that you assigned to each product.

CategoryList - This column displays what category or categories that product is listed in.

ProductStatus - This column displays which current stock status the product is set for. (Example: in stock, out of stock, discontinued.

Bullets - Displays a list of the bullet text that is assigned to the product.

ShortDescriptionForCategoryList -  This description will appear on the Category page next to the Item Name and Thumbnail. It will also appear in the product group display next to item number.

BasePrice - Your base selling price for this product.  All price adjustments are built upon or modify this amount.

RetailPrice - The manufacturer's suggested retail price for this product.

Cost - Your cost of goods sold.

Manufacturer - Displays the product's Manufacturer or Brand.

ManufacturerPartNumber - The manufacturer's identifying code for each product.

AdvancedPricing - Displays the advance pricing that is set for individual products.

ItemImages - This displays the image paths that are set for all images associated with a specific product and shows whether they are set to be viewed or hidden.

ItemPrimaryImageUrl - This displays the image paths that are set for the primary images associated with a specific product.

ItemPrimaryImageAltText -  This displays the alt text for the primary images associated with a specific product.

ItemThumbnailUrl - If you use your own thumbnail images and not the ones that are automatically generated, this will show you the URL path where they are stored on the server.

ItemThumbnailAltText - This displays the alt text for the thumbnail images associated with a specific product.

UseTabs - This field is used to set whether specific products will use tabs on the product details page.

UseTabsThemesOverride - This is used to turn theme tabs override on or off.

RelatedProductNameOverride - This is used to turn the related product tab override on or off. You can then rename the tab.

LongDescription1 -  Used to edit the data in the long description#1.

LongDescriptionName1 - Used to edit the name of long description#1.

LongDescription2 -  Used to edit the data in the long description#2.

LongDescriptionName2 - Used to edit the name of long description#2.

LongDescription3 -  Used to edit the data in the long description#3.

LongDescriptionName3 - Used to edit the name of long description#3.

LongDescription4 -  Used to edit the data in the long description#4.

LongDescriptionName4 - Used to edit the name of long description#4.

LongDescription5 -  Used to edit the data in the long description#5.

LongDescriptionName5 - Used to edit the name of long description#5.

LongDesc1ExternalUrl - Used to the edit the URL of long description#1.

LongDesc2ExternalUrl - Used to the edit the URL of long description#2.

LongDesc3ExternalUrl - Used to the edit the URL of long description#3.

LongDesc4ExternalUrl - Used to the edit the URL of long description#4.

LongDesc5ExternalUrl - Used to the edit the URL of long description#5.

BulletsExternalUrl - This pulls the content of another page into the content area of your site. You can put http://www.google.com here and it will load that page into your site.

SizeHeight -  - Used to define the items height for shipping.

SizeLength - Used to define the items length for shipping.

SizeWidth - Used to define the items width for shipping.

SizeUnit - Used to define the items measurement unit.

Weight - Used to set the shipping weight of a specific product.   

WeightUnit - Used to set which units of weight measurement to apply each product.

MinimumOrderQuantity - Used to set the minimum number of units required for purchase of a specific product.

MaximumOrderQuantity - Used to set the maximum number of units required for purchase of a specific product.

WarehouseName - Used to assign a specific warehouse to a product.

CallForShippingFlag - Used to turn on the “Call for Shipping” option.

ShipsIndividually - Use this field to mark an item to ship by itself.

NonShippingItem - Use this field to mark at item as a product that does not ship.

CallForPricingFlag - Enables the “Call for Pricing” price option.

NoTax - This marks the item as a non-taxable item.

CustomMetaKeywords - This field displays the text from the “Page Keywords” field in your “Product Text” section of the General tab in the product editor. The information that you provide in a Meta tag is used by search engines to index a page so that someone searching for the kind of information the page contains will be able to find it. This should include frequently used keywords relating to this product.

CustomMetaDescription - This field displays the text from the “Page Description” field in your “Product Text” section of the General tab in the product editor. The Meta description tag describes your site's content, giving search engines an accurate summary filled with multiple keywords.

CustomPageTitle - Used to give your page a custom title. This will appear on the top bar of the browser and in search engine results. By default, the product name and manufacturer are used for the page title.

InactiveStoreList - This field is used to set an item as inactive for specific stores.

QuickBooksListID - Defines individual Quick Book list IDs.

IsQuickBooksGroup - This setting tells your store that the group is a Quick Books group.

SortOrder - By placing a number in this box, your Product will appear in the Catalog in the order you select, ascending from 0. If you do not place a number, the Products are sorted alphabetically. Can also put negative numbers like -1, -2, -3 in this box as well.

Variation1Group - Used to set which variant group is assigned to specific products.

Variation1Description - This displays the “Public Description” associated with that specific variant group.

Variation1Surcharge - Used to set the surcharge assigned to a specific variant.

Variation1SurchargeType - Used to set which type of surcharge is applied (total, plus percent, plus dollars, ect..)

Variation1ItemNumberExtension - Identifies the extension unmbers or letters used to represent a variant.

Variation2Group -  Used to set which variant group is assigned to specific products.

Variation2Description - This displays the “Public Description” associated with that specific variant group.

Variation2Surcharge - Used to set the surcharge assigned to a specific variant.

Variation2SurchargeType - Used to set which type of surcharge is applied (total, plus percent, plus dollars, ect..)

Variation2ItemNumberExtension - Identifies the extension numbers or letters used to represent a variant.

Variation3Group -  Used to set which variant group is assigned to specific products.

Variation3Description - This displays the “Public Description” associated with that specific variant group.

Variation3Surcharge - Used to set the surcharge assigned to a specific variant.

Variation3SurchargeType - Used to set which type of surcharge is applied (total, plus percent, plus dollars, ect..)

Variation3ItemNumberExtension - Identifies the extension numbers or letters used to represent a variant.

QuantityDiscount1Quantity - This field is used to define quantity discount #1.

QuantityDiscount1Price - This field is used to define the price for quantity discount #1.

QuantityDiscount2Quantity - This field is used to define the price for quantity discount #2.

QuantityDiscount2Price - This field is used to define the price for quantity discount #2.

QuantityDiscount3Quantity - This field is used to define the price for quantity discount #3.

QuantityDiscount3Price - This field is used to define the price for quantity discount #3.

QuantityDiscount4Quantity - This field is used to define the price for quantity discount #4.

QuantityDiscount4Price - This field is used to define the price for quantity discount #4.

QuantityDiscount5Quantity - This field is used to define the price for quantity discount #5.

QuantityDiscount5Price - This field is used to define the price for quantity discount #5.

QuantityDiscount6Quantity - This field is used to define the price for quantity discount #6.

QuantityDiscount6Price - This field is used to define the price for quantity discount #6.

QuantityDiscount7Quantity - This field is used to define the price for quantity discount #7.

QuantityDiscount7Price - This field is used to define the price for quantity discount #7.

QuantityDiscount8Quantity - This field is used to define the price for quantity discount #8.

QuantityDiscount8Price - This field is used to define the price for quantity discount #8.

QuantityDiscount9Quantity - This field is used to define the price for quantity discount #9.

QuantityDiscount9Price - This field is used to define the price for quantity discount #9.

QuantityDiscount10Quantity - This field is used to define the price for quantity discount #10.

QuantityDiscount10Price - This field is used to define the price for quantity discount #10.

SpotLightItem - Used to mark a product as a spotlight item.

FeaturedItem - Used to mark a product as a featured item.

CustomFlag1 - Used to enable custom flag #1

CustomFlag2 - Used to enable custom flag #2

CustomFlag3 - Used to enable custom flag #3

DuplicateRowOnlyAddCategoryData -

OverwriteAllDataWithThisRow -

Hide - Use this field to set a product as hidden or visible.

AttributeList - Sets the list of attributes associated with individual products.

ProductUrl - System defined URLs for individual items

CustomUrl - Used to define custom URLs for individual items.

RelatedItemsList - Related items associated with individual products.

ProductGroup - Sets which product group a product is in.

ProductGroupType - Determines if an product is group with other products.

NumberInStock - Used to define the number in stock of each product.

LowStockQuantity - Used to define the low stock number for each product.

LowStockWarningsEnabled - Enables the low stick warning notification.

LimitShippingRegion - Use this field to exclude specific shipping regions.

BreakOutShipping - Marks an item for breakout shipping.

ShippingClassificationCode - Enter a classification code to have items grouped together in the same package(s) for the purposes of calculating shipping.

CallForShippingWholeOrder - When selecting this, the whole order will be treated as Call for Shipping.  A Call for Shipping message will be displayed in the cart and on the order.  Shipping would be collected outside the system.

DropShipping - Use this flag to indicate that the product is Drop Shipping.  This allows a custom drop shipping message to be displayed that will show on the product details, cart, order and order emails.

DeleteProduct - Input TRUE to delete the product.

Discontinued - This field is used to mark an item as Discontinued.

ETADate - Used to specify an estimated time of arrival date.

ShippingAdjustmentType - Determines which type of rate adjustment is applied to the individual item.

ShippingAdjustments - This field turns shipping adjustments on or off.

TaxCode - Used for tracking the tax identifier on products for tax calculation purposes.

UseMapPricing - Mark true or false to enable or disable map pricing for individual items.

LastItemNr - Displays data that is shown in the ‘Last Item Number’ field.

DoNotDiscount - Used to mark an item as one that will not allow discounts to apply to it.

Personalizations - This field adds specific personalizations to individual products.

HeadTags - The Meta description tag describes your site's content, giving search engines an accurate summary filled with multiple keywords.

HandlingFee - Used to define the handling charges for the specific product.

eProductType - Used to set how the customers retrieve eProducts.

eProductDeliveryLinkAction - Used to set how the how to deliver the product once the order is verified.

eProductRandomExpireDays - Determines the amount of days until the random email verification link for eproducts expires.

eProductMultipleDelivery - Determines the method used to deliver an eproduct that contains multiple files.

eProductURL - Specify the location URL of the delivery for an eproduct.

eProductEmail - The URL path assigned to an eproduct.

eProductSerialNumberFilePath -

CustomUpsellPageURL - The custom URL that is assigned to an upsell page.

MultiplesOfQuantity -  

StartingQuantity - Defines the starting quantity of an item when added to cart.

GTIN - The Global Trade Item Number for this item. GTINs include UPC (in North America), EAN (in Europe and elsewhere), JAN (in Japan), and ISBN (for books).

IsSubscriptionProduct - Used to mark a product as a subscription.

SubscriptionFrequency - Used to set the frequency with which a subscription is sent or renewed.

SubscriptionFrequencyType - Used to set the frequency type with which a subscription is sent or renewed (days, weeks, months, years, ect..).

RequireCreditCard - Sets whether an item can be purchased with only a credit card payment method.

NonInventory - Marks whether an item is non-inventory or not.

ExcludeFromCommissions - Determines whether an item is excluded from sales commissions.   

AddToCartMessage - Used to assign an add to cart message.

NoPriceMask - By marking this field as ‘True’, you can use this field to override the default $0 text "FREE" on a per product level.

DaysUntilReorderAllowed - Used to enable or disable the ‘Days Until Reorder Allowed’ function. When an order is placed and an item on the order has a value in this field, the order history for that item is checked for that time frame. If other orders are found within the time frame then the new order item is flagged as "Item Reordered Too Early." This can be used with approval systems, etc.

ForceSeparateOrder - Used to enable or disable the ‘Approval Required’ function. If an item with this flag set is added to the cart with other items it will cause a cart validation message and not allow checkout unless it is the only item in the cart.

ApprovalRequired - Used to enable or disable the ‘Approval Required’ function. Approval from the merchant will be required for orders placed containing items with this flag.

EarnsPoints - Used to determine whether or not an item earns rewards points from purchase.

InelligibleForPurchaseByPoints - Marks the item eligible for rewards points.

AdditionalPointsEarned - Identifies additional points acquired for the purchase of each individual item.

Back to top

 

Customer Import/Exports

CustomerNumber - This will simply assign the customer that number. They will still be assigned a different ID in the Americommerce Spark Pay Online Stores system, but the number field can be used to verify data.

Username - This is a profile feature kind of like a facebook or something. Most of the time customers do not have one at all, or it is set as their email address. When logging in, their is a profile section where information can be changed, and this is where customers see their username.

SalesRep - Most of the time this field is left blank. You can set this to have a customer associated with a particular user (aka. sales person). Most of the time this is used in companies that provide commission sales.

Password - The password field can only be used to add passwords in bulk. This means that your current cart would have to provide the password in text form, and not in **** for the import to assign the passwords correctly.

CustomerType - All of the customer types can be created on the back end by going to Settings > People > Customer Types. Then once created you simply add the desired name to this field.

OnEmailList - This is the flag to include the customer in your mailing lists. If you use your mailing lists for promotions and advertisements like most people do, then the effect of Do Not Promote can be achieved. Just make sure the is set to FALSE so they don't receive the emails.

AdCode - An AdCode is a reference to a specific advertisement, usually a keyword or email campaign. It shows where visitors, customers, and orders originate. It can be used with 3rd party companies to track where site traffic is coming from. Often left blank.

DefaultPaymentMethod - The options for this field are: Credit Card, PayPal, Reward Points, Gift Certificate. Most of the time this is set to credit card or not set at all.

AssociatedParentCustomers - This is often used in referral programs. If one customer refers another and then is supposed get a discount or something, that is how this is used.

DeleteCustomer - This is to remove customers in a mass amounts. Simply put TRUE to delete the customer and FALSE to keep them.

OpenBalance - This is the balance that the customer currently owes you. More than likely, the most recent order total.

TotalBalance - This is the total amount owed by the customer. The difference between Open Balance and Total Balance is that the open balance can be affected by quotes that have had partial payments and the total balance remains the same until the transaction is complete.

Back to top

 

Product Variant Inventory Import/Export

VariantInventoryID - System assigned variant ID number.

ItemNumber - User assigned item number.

VariantInventoryItemNumber - The extension assigned to a variant.

CombinedVariants - Used when combing variants for variant inventory. Use a Vertical Bar to combine variants. Ex: Variant1|Variant2

NumberInStock - The available stock number.

ManufacturerItemNumber - User assigned manufacturer item number.

Weight - Product weight that is used to calculate shipping prices.

ProductStatus - Used to set the product status of each individual product.  

DeleteVariantInventory - This field can be used to clear the variant inventory assigned to individual products.

QuickBooksListID - Defines individual Quick Book list IDs.

GTIN - The Global Trade Item Number for this item. GTINs include UPC (in North America), EAN (in Europe and elsewhere), JAN (in Japan), and ISBN (for books).

LowStockQuantity - Used to designate what number will trigger the low stock notification.

Back to top

 

Category Import/Export

CategoryId - The system assigned ID for the category.

CategoryName - The user assigned name of a category.

ShortCategoryDescription - The short description on category pages.

SortOrderCategory - Determines the sort order of products in a category.

HideCategory - Hides individual categories.

MaxQuantityInCategory - Defines how many products of each category are displayed on the specific category page.

CategorythumbnailImage - Sets the URL path used for category thumbnail images.

CategoryPageTitle - The page title of a category. This is the text that will appear in the title bar of the customer’s browser.

CategoryKeywords - The keywords associated with a category.

MetaCategoryDescription - The keywords associated with a category. General description of the category.  These are special HTML tags with text values that help with search engine optimization. These tags and values are not visible to customers.

CategoryLookup - The category path a product is located (Custom Desktops > Apple Desktops > Apple iMac).

FooterForCategory - Determines which footer layout will be used for the specific category page.

HeaderForCategory - Determines which headerlayout will be used for the specific category page.

CategoryImage - Assigns an image to the top of a category page.

ExternalContentPath - If there is external content on the category page, the URL path is defined here.

DisplayCategoryContents - Determines whether or not category contents are displayed.

ShowProductsForSubs - Used to set whether or not products display for subcategories.

CustomUrl - Custom URL for a specific category that is defined by admin users.

CategoryUrlFinal - Used to set the URL path for a specific category.

AlternateThumbnail - Used to assign alternate thumbnails to a category.

HeadTags - The Meta description tag describes your site's content, giving search engines an accurate summary filled with multiple keywords.

Back to top

 

Product Pricing Import/Export

ProductPricingID - The specific ID assigned to a products custom pricing.

ItemID - This is the number that is created and assigned by the system when a product is first created or imported. This number is predominantly used as an identifier for each specific product in the database. We recommend that this number is never changed and is always included in your imports.

ItemNumber  - This is the item number that you set for each of your products. Most often referred to as Item “Number (SKU)”, this number can be changed or modified at your discretion.

PriceStore - Used to determine which store the pricing is being set or edited for.

PriceCustomerLevel - Defines customer type for the pricing.

PriceVariant - Used to set the variant pricing.

PriceVariantInventory - Defines pricing for a variant inventory item.

PriceStartDate - Start date for a specific price.

PriceEndDate - End date for a specific price.

PriceQuantity - Defines quantity pricing.

Cost - Sets the cost.

Price - Sets the price.

PriceVariantSurcharge - Adds an additional surcharge to the variant.

PriceCalculation - Used to assign a price calculator to a specific product.

DeletePricing - Used to delete the current pricing.

Back to top

 

Have more questions? Submit a request

Comments

  • Avatar
    Lucia Reid

    Seems some fields are required when you import a file BUT these are not mentioned anywhere (?) when you create a custom export. I wanted to change one field in products so created a "custom export." Can't import it since "required" fields are missing. The export page should say which fields are mandatory and there should be an asterisk next to each required field when you try to make a custom export file. Would help if this were mentioned in the help on the data export page - and this article.