Skip to main content

Data types imported from Turn14 Distribution

A
Written by Anna Verbichenko
Updated today

As explained in the article How imported product and catalog data appears in your X-Cart store, a successful product import from Turn14 Distribution can populate your store with a wide range of data. The table below outlines the specific types of data that may be imported.


Products

Product data includes the essential details about each item in your catalog, such as name, SKU, price, description, and images. This information helps customers understand what the product is, how it can be used, and whether it fits their vehicle. These details can be added to your store’s catalog automatically as a result of product import.

Data type

Imported via Turn 14

Product name*

X-Cart field: Product name (See product details)

Is automatically generated from components imported via the auto integration, following the format defined in the "Product name formula" field within the brand import settings.

Can be adjusted manually for imported products.

Yes

SKU

X-Cart field: SKU (See product details)

Is automatically generated from components imported via the auto integration following the format defined in the "New Product SKU" section within the brand import settings.

Can be adjusted manually for imported products.

Caution: Editing the SKU manually may disrupt future product updates via auto integrations if SKU is used as the identifier to match incoming data with existing products in your store (check the “Update existing products by” setting in Import options).

Yes

MPN

X-Cart field: Manufacturer Part # (See product details)

Can be adjusted for imported products manually.

Caution: Editing the MPN manually may disrupt future product updates via auto integrations if MPN is used as the identifier to match incoming data with existing products in your store (check the “Update existing products by” setting in Import options).

Yes

UPC

X-Cart field: Barcode (ISBN, UPC, GTIN, etc.) (See product details)

Can be adjusted for imported products manually.

Caution: Editing the UPC manually may disrupt future product updates via auto integrations if UPC is used as the identifier to match incoming data with existing products in your store (check the “Update existing products by” setting in Import options).

Yes

Description*

X-Cart field: Description (See product details)

Is automatically generated from components imported via the auto integration. Features & Benefits are included as bullet points at the end of field contents, if available in Turn14.

Can be adjusted manually for imported products.

Yes

Full description*

X-Cart field: Full description (See product details)

Is automatically generated from components imported via the auto integration. Features & Benefits are included as bullet points at the end of field contents, if available in Turn14.

Can be adjusted manually for imported products.

Yes

Images*

X-Cart field: Images (See product details)

Adjustments for imported products can be made manually.

Yes

Weight*

X-Cart field: Weight (See the "Shipping" section of product details)

Can be adjusted manually for imported products.

Yes

Dimensions*

X-Cart fields: Lenght + Width + Height (See the "Shipping" section of product details)

Can be adjusted manually for imported products.

Yes

Fitments*

It is a list of vehicles a product fits, presented in the same Make/Model/Year/Submodel (MMY) format used for importing vehicles.

Yes

Prices*

Selling price can be calculated from pricing data importable via the auto integration according to the Pricing Strategy rules that can be adjusted in brand import settings.

Imported price types:

  • MAP

  • Jobber

  • Retail

  • Cost

Each price type is stored separately.

Stored pricing data previously obtained from Turn14:

  • is overwritten by re-imports from Turn14;

  • is not overwritten by re-imports from other integrations (pricing data from each integration is stored separately).

Yes

Stock*

Imported stock data includes both the total stock quantity and the stock available by individual Turn14 warehouse location. After import, the total stock quantity for products brought in via the auto integration can be viewed on the product list pages in the Admin area. On the Inventory tab of the product details page, you can view both the total stock quantity and a breakdown of stock levels by warehouse location.

Yes

Attributes*

For detailed information on supported attributes, see the Attributes table below.

Yes

💡 The types of product data marked with an asterisk (*) can be updated (overwritten) by subsequent imports from Turn14. Specific data types to be updated can be specified in the auto integration's Import options.


Attributes

In X-Cart, attributes are technical characteristics that describe a product in more detail and support various business and regulatory needs. Some attributes are used to help customers filter and find items compatible with their vehicle (such as by rim diameter, bolt circle, or section width). Others ensure compliance with legal requirements, inform customers, or support operational processes (for example, CARB-related attributes are used to properly label products and may restrict their availability for sale in certain regions). Attributes can be imported as part of the product data.

Data type

Imported via Turn 14

Safety & Compliance

  • Prop 65 Yes/No

  • Epa

Yes

Wheel & Tire

No


Categories

Categories organize your catalog into logical groups, like wheels, tires, or brakes, making it easier for customers to browse products. Well-structured categories help buyers find what they need quickly and guide them through your store efficiently.

A category from the Turn14 catalog will appear in your store only if at least one of its products is successfully imported.

Data type

Imported via Turn 14

Category name (path)

This data type is used to determine the name and the hierarchical path of a product's category.

When importing product data via the auto integration, X-Cart uses the Category name (path) data provided by the supplier to determine where the product should be placed in your store’s catalog. Depending on the category mapping rules configured for the integration, X-Cart will either:

  • Create a new category in your store, replicating the name and structure from the supplier’s catalog — if the supplier's category is not mapped to an existing one in X-Cart;

  • Use an existing category — if the supplier's category is mapped to an existing X-Cart category. In this case, the product will be placed into the matched category instead of creating a new one.

Yes


Brands

Brands represent the manufacturers of the products in your catalog.

A brand from the Turn14 catalog will appear in your store only if at least one of its products is successfully imported.

Data type

Imported via Turn 14

Brand name

X-Cart field: Brand name (See brand details)

Can be adjusted manually:

Yes

AAIA Brand ID

X-Cart field: Brand AAIA ID (See brand details)

Can be adjusted manually:

Yes

Brand logo

X-Cart field: Brand logo (See brand details)

Can be adjusted manually for imported products in brand settings.

Yes

💡 You can find out how brands from auto integrations are connected with your store's brands on the Catalog Import > Brand mapping page.


Vehicles

Vehicles are structured data sets that are imported in one of the following two formats:

  • Make/Model/Year/Submodel

  • Make/Model/Year/Trim (ATD)

These formats are the standard way automotive catalogs link parts to vehicles and are essential for setting up accurate product fitment.

Importing vehicles this way lets you instantly add thousands of models from the past 40+ years, making it easier to match customers with the right parts. It also keeps your vehicle list current with the latest models.

Data type

Imported via Turn 14

Vehicles

Vehicles cannot be imported from Turn 14. To add them to your catalog, set up other integrations like AutoSync (recommended), ATD, and SEMA, or request assistance from our support team.

No


Can't find answers you're looking for?

Email us at support@x-cart.com. We will be happy to help!


Did this answer your question?