Shopping Cart Elite Data Mapping Field Names
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKL
1
TYPEActiveRequired (Add New Products)Required (Update Products)DateField NameDefinition and UseExampleAccepted ValuesAccepted FormatsValidation ChecksCharacter Limit
2
YesRequiredRequiredaction(Required for batch update) This is used for batch update to specify if you want to add, update or delete records.
In order to update a record you are required to add Action, Spider URL or ProductID,Product Type and Part Number.
If you want to remove a whole product you need to put removeall. If you want to remove a part number - put remove
removeadd, update, remove, removeall
3
YesRequiredRequiredProduct TypeThis will allow you to define which template to trigger.MERCHANDISE: 1 = Universal / 2 = Product with Options
AUTOMOTIVE: 3 = Vehicle
SERVICE = UniversalWithSubscriptions = 5
1
4
YesOptionalOptional1/4/2014Merchandise TypeThis will allow you to define merchandise type of the product. Merchandise = 1 / Service = 2 / BundleMerchandise = 3 / ComboMerchandise = 4 / BundleService = 51
5
YesOptionalOptional3/1/2015ActiveIf you want to take a product live or put it in Final ValidationApprove = 1 / 0= Final Validation
6
YesRequiredOptionalProduct TitleLonger description than anchor text of what the product is,and used for SEOAEM Short Ram Intake for b;azing performance and better gas milage.An alphanumeric string; 1 character minimum in length and 130 characters maximum in length. Note: Type 1 High ASCII characters (®, ©, ™, etc.) or other special characters are not supported.If missing using anchor text

Remove any unwanted characters
250
7
YesRequiredOptionalAnchor TextThis text is displayed as a link on all the webpages for the productAEM Short Ram IntakeAn alphanumeric string; 1 character minimum in length
Note: Type 1 High ASCII characters (®, ©, ™, etc.) or other special characters are not supported.Title Case suggested.Block products with "--","&","0xDIGIT" inside
Make sure when moving data over you will have the right cases (Titles case)

DO NOT PUT THE BRAND NAME OF THE PRODUCT IN FRONT OF THE ANCHOR TEXT

Remove any unwanted characters


Note that the anchor text is used to display the name in the search result, the title is not used.
100
8
YesRequiredOptional2/25/2014Spider URLThis is the URL that will be used to make the product page URL and to build unique productstext1-text2-text3-text4-text5Remove any unwanted characters100
9
YesOptionalRequiredprodid*** THIS FIELD CAN BE USED TO TRIGGER AN UPDATE IN BATCH UPDATE ****

If
you export your products from SCE, it will populate Prodid. This is the
same as Spider URL except it will know exactly what product it is
without worrying of misspelling of anchor text, or brand. This is a more
reliable way to run updates not necessary.
Numbers only
10
yesOptionalOptional3/20/2014Amazon TitleRemove any unwanted characters200
11
yesOptionalOptional3/20/2014Amazon Description
0
12
yesOptionalOptional3/20/2014eBay Title200
13
yesOptionalOptional3/20/2014eBay Description0
14
YesOptionalOptionalSub TitleWill show up under the title. Opportunity to add additional features/benefitsAEMAn alphanumeric string; 1 character minimum in length and 130 characters maximum in length. Note: Type 1 High ASCII characters (®, ©, ™, etc.) or other special characters are not supported.150
15
YesOptionalOptional3/20/2014Screen TitleThis text displayed instead of Product Title on the product pageCheck if the title on the page is different from the title of the URL. If it is then put the page title here500
16
YesRecommendedOptionalallow new brandAuto Add Brands that are missing when uploading new products1Blank or 1 (1 means it will create it)
17
YesRequiredOptionalBrandBrand NameAEM Short Ram Intake AEM short ram intake systems are an economical alternative to our cold air systems and deliver performance,
value and ease of installation. Our short ram intakes install easily under the hood and cost less because we use less material to manufacture them.
Letters and Numbers, avoid special characters. For example replace "&" by "and"If missing Websitename with .com
Make Sure it is no all CAPS
50
18
YesRequiredOptionalDescriptionA text description of the product. Letters and Numbers, avoid special characters. Optimize for keywords.
Any non-ASCII charecters will be tranformed to "?" including no-break spaces, en and em dashes,®, ©, ™ etc.
If missing use the product title

Use the compresshtml , hexinjection , removedirtydata methods for formatting of strings.

DO NOT Grab Reviews, testimonials or customer experience lines about the products. It should only be the description about the product. Exclude any pitches to call the website or email them.

HTMLs allowed are
<p>
<br>
<b>
<strong>

Make sure you have proper spacing between words
32767
19
YesOptionalOptionalAdditional DescriptionSpecial important informationFor Complete Installation Instructions Click the Link Below and Enter Your Part Number. Note: This shows up below the description under title: Additional Information.Letters and Numbers, avoid special characters.
Any non-ASCII charecters will be tranformed to "?" including no-break spaces, en and em dashes,®, ©, ™ etc
4000
20
YesOptionalOptionalAdditional Description 2Special important informationFor Complete Installation Instructions Click the Link Below and Enter Your Part Number. Note: This shows up below the description under title: Additional Information.Letters and Numbers, avoid special characters.
Any non-ASCII charecters will be tranformed to "?" including no-break spaces, en and em dashes,®, ©, ™ etc
4000
21
YesOptionalOptionalAdditional Description 3Special important informationFor Complete Installation Instructions Click the Link Below and Enter Your Part Number. Note: This shows up below the description under title: Additional Information.Letters and Numbers, avoid special characters.
Any non-ASCII charecters will be tranformed to "?" including no-break spaces, en and em dashes,®, ©, ™ etc
4000
22
YesOptionalOptionalAdditional Description 4Special important informationFor Complete Installation Instructions Click the Link Below and Enter Your Part Number. Note: This shows up below the description under title: Additional Information.Letters and Numbers, avoid special characters.
Any non-ASCII charecters will be tranformed to "?" including no-break spaces, en and em dashes,®, ©, ™ etc
4000
23
YesRecommendedOptionalBullet PointBrief descriptive text, called out via a bullet point, regarding a specific aspect of the product. Please check accepted values on how to seperate the bulletsLetters and Numbers, avoid special characters.
To seperate bullet points use <br> tag or ~!~
Any non-ASCII charecters will be tranformed to "?" including no-break spaces, en and em dashes,®, ©, ™ etc
bullet1~!~bullet2
bullet1<br>bullet2
Remove any unwanted characters1000
24
yesRecommendedOptional2/25/2014primary keywordPrimarySEOKeyword60
25
yesRecommendedOptional2/25/2014secondary keywordSecondarySEOKeyword60
26
yesRecommendedOptional2/25/2014tertiary keywordTrietarySEOKeyword60
27
YesRequiredOptionalMETA DescriptionHow search engines list your site in engines. Generally not an influence in ranking on most engines, it still gets shown as text to support a listing in natural search and does influence click through rate and relevance.AEM short ram intake systems are an economical alternative to our cold air systemsLetters and Numbers, avoid special characters. For example replace "&" by "and".
Limited to 100 characters
Make sure this field is perfectly moved over from the old website

If missing use the product title

500
28
YesRequiredOptionalMETA KeywordsNot a factor in Google currently, but other engines use it to relate content to groups of keyterms with thisshort ram, intake, horsepower, torqueLetters and Numbers, avoid special characters. For example replace "&" by "and".
Limited to 10 words
Make sure this field is perfectly moved over from the old website

If missing use the product title and seperate each keyword through comma
1000
29
YesOptionalOptional08/16/2018Spider RuleAllws you to set the spider rule to index nodex archive no archive on the product page0 - Index Follow
1 - NoIndex NoFollow NoArchive
2 - NoIndex Follow NoArcive
3 - Index Follow NoArcive
1Spider Rule Should by default will always be 0 if you are hidding product you can change it to any of the accepted values as required1
30
YesOptionalOptionalGeneral Image TagsAllow to add image alt tags in a seperate columns using a comma
red tape, green tape, blue tapekeyword,keyword,keyword (each keyword is for each image, to skip an image just leave a blank keyword between commas)Make sure this field is perfectly moved over from the old website
31
YesRequiredOptionalGeneral ImageUse ^#### to set specific image size to upload . URL should end with .jpg,.gif or .png extentions
There should not be any blank space in between comma
http://www.aemintakes.com/images/intake-md.png,http://www.aemintakes.com/images/intake-md2.png^1500Must be a valid address in the format: http://xxxxxxxxxxxxxx.xxx (add more than one through commas)http://abc/xyz.jpg,http://abc/xyz.jpg,http://abc/xyz.jpgMake sure you do not have duplicate images here during migration

If missing put http://mnit.ac.in/new/PortalProfile/images/faculty/noimage.jpg

There should not be any blank space in between comma separators of Image format

In general image ensure that you have only the URL and not other prefixes (Ex: ITEMURL2=…)
32
YesOptionalOptional11/18/2014overwrite imageIf you need to reupload the image from within the store because you are reloading the product under a different spider URL1Blank or 1 (1 means it will overwrite it)
33
YesRecommendedOptionalallow new categoryAuto Add CATEGORIES that are missing when uploading new products1Blank or 1 (1 means it will create it)
34
OptionalOptional4/23/2018Main Category IDCategory ID is avialble when you export the data from SCE
35
YesRequiredOptional2/25/2014Main CategoryThe top level of product organization. All products must have a categoryAir IntakesLetters and Numbers, avoid special characters. For example replace "&" by "and".Use title case unless client indicated otherwise (check their old website)

Categories should contain the same case preferably title case
50
36
YesOptionalOptional2/25/2014Main Category Meta TitleRemove any unwanted characters250
37
YesOptionalOptional2/25/2014Main Category Meta Keywords250
38
YesOptionalOptional2/25/2014Main Category Meta Description250
39
YesOptionalOptional2/25/2014Main Category Spider URLMUST EXIST IF YOU ARE MIGRATING OVER
40
YesOptionalOptional2/25/2014Main Category Redirect URLMUST EXIST IF YOU ARE MIGRATING OVER
41
YesOptionalOptional2/25/2014Main Category Image URL
42
yesRecommendedOptional3/20/2014Main Category Amazon CategoryCategories should contain the same case preferably title case
43
yesRecommendedOptional3/20/2014Main Category Amazon Category ID
44
yesRecommendedOptional3/20/2014Main Category ebay Category
45
yesOptionalOptional4/23/2018Sub Category IDSub Category ID is avialble when you export the data from SCE
46
YesRequiredOptionalSub CategoryThe second and middle level of product organzation. All products must have a Sub CategoryShort RamLetters and Numbers, avoid special characters. For example replace "&" by "and".Use title case unless client indicated otherwise (check their old website)50
47
YesOptionalOptional2/25/2014Sub Category Meta Title
48
YesOptionalOptional2/25/2014Sub Category Meta Keywords
49
YesOptionalOptional2/25/2014Sub Category Meta Description
50
YesOptionalOptional2/25/2014Sub Category Spider URLMUST EXIST IF YOU ARE MIGRATING OVER
51
YesOptionalOptional2/25/2014Sub Category Redirect URLMUST EXIST IF YOU ARE MIGRATING OVER
52
YesOptionalOptional2/25/2014Sub Category Image URL
53
yesOptionalOptional3/20/2014Sub Category Amazon Category
54
yesOptionalOptional3/20/2014Sub Category Amazon Category ID
55
yesOptionalOptional3/20/2014Sub Category Ebay Category
56
yesOptionalOptional4/23/2018Section Category IDSection Category ID is avialble when you export the data from SCE
57
YesOptionalOptionalSection CategoryThe lowest level of product organization. Usually the brand nameAEMLetters and Numbers, avoid special characters. For example replace "&" by "and".Use title case unless client indicated otherwise (check their old website)

Categories should contain the same case preferably title case
58
YesOptionalOptional2/25/2014Section Category Meta Title
59
YesOptionalOptional2/25/2014Section Category Meta Keywords
60
YesOptionalOptional2/25/2014Section Category Meta Description
61
YesOptionalOptional2/25/2014Section Category Spider URL
62
YesOptionalOptional2/25/2014Section Category Redirect URLMUST EXIST IF YOU ARE MIGRATING OVER
63
YesOptionalOptional2/25/2014Section Category Image URL
64
yesOptionalOptional3/20/2014Section Category Amazon CategoryCategories should contain the same case preferably title case
65
yesOptionalOptional3/20/2014Section Category Amazon Category ID
66
yesOptionalOptional3/20/2014Section Category Ebay Category
67
YesOptionalOptionalCross sell main cat 1Add a category name to cross sell your product inValid category nameCategory must be created in backoffice for it to map or put column 'allow new category' in the batch file50
68
YesOptionalOptionalCross sell sub cat 1Add a sub category name to cross sell your product inValid sub category nameCategory must be created in backoffice for it to map or put column 'allow new category' in the batch file50
69
YesOptionalOptionalCross sell sec cat 1Add a section category name to cross sell your product inValid section category nameCategory must be created in backoffice for it to map or put column 'allow new category' in the batch file50
70
YesOptionalOptionalCross sell main cat 2Add a category name to cross sell your product inValid category nameCategory must be created in backoffice for it to map or put column 'allow new category' in the batch file50
71
YesOptionalOptionalCross sell sub cat 2Add a sub category name to cross sell your product inValid sub category nameCategory must be created in backoffice for it to map or put column 'allow new category' in the batch file50
72
YesOptionalOptionalCross sell sec cat 2Add a section category name to cross sell your product inValid section category nameCategory must be created in backoffice for it to map or put column 'allow new category' in the batch file50
73
YesOptionalOptionalCross sell main cat #

(You can now put unlimited about of categories to load into related, however make sure you import and create them in categories before loading them through batch update)
Add a category name to cross sell your product inValid category nameCategory must be created in backoffice for it to map or put column 'allow new category' in the batch file50
74
YesOptionalOptionalCross sell sub cat #

(You can now put unlimited about of categories to load into related, however make sure you import and create them in categories before loading them through batch update)
Add a sub category name to cross sell your product inValid sub category nameCategory must be created in backoffice for it to map or put column 'allow new category' in the batch file50
75
YesOptionalOptionalCross sell sec cat #

(You can now put unlimited about of categories to load into related, however make sure you import and create them in categories before loading them through batch update)
Add a section category name to cross sell your product inValid section category nameCategory must be created in backoffice for it to map or put column 'allow new category' in the batch file50
76
YesOptionalOptional2/28/2014SpecificationsAdditional product information, usually physical facts.Ex:

## = Seperator between category title and description
~ = Seperator between description and value
~ = Seperator if this specification is visible or not (optional: 0 = hidden / 1 = visible) (if you do not provide this it will be "1" by default)

^ = Seperator between the next description and value
| = Seperator for the next category
----

NOTES:

Amazon Marketplace Only:
If no ASIN in specificaiton then it will try to create new ASIN
If ASIN is in specification then this product will sync to the original ASIN
If you are trying to map this product to multiple ASIN then use
ASIN1, ASIN2, ASIN3, ASIN4, ASIN5, ASIN6, ASIN7, ASIN8, ASIN9, ASIN10
Use "ebay title" and "amazon title" description to overwrite titles
Use "amazon description" overwrites the description
Letters and Numbers, avoid special characters. For example replace "&" by "and".
Ex: Material Stainless Steel, Warranty 3 years, Color Fire Engine Red, Brand AEM
SpecificationCategory##Description~Value~1|Specifications2##DescriptionA~ValueA~0^DescriptionB~ValueB~0|Specifications3##DescriptionC~ValueC~0^DescriptionD~ValueD~0

Specification##Manufacturer~Alimed^Application~Zip-Up Butterfly Vest^For Use With~Wheelchair^Specifications~Large, Male^UNSPSC Code~42192208^UOM~EA/1^Part Number~79164200
Make sure that if all the specification are
title case or lower or uppercase you will change to title case

If importing Amazon specifications do not all
the category “Amazon” call it “Details”
 
If importing Amazon specifications some fields
might be Amazon only and some on universal that can be used for the website,
ask the client which ones he wants visible and which ones hidden

500 per spec 2000 in all
77
YesOptionalOptional11/25/2014Specification 1

If you would like to give it a title other than general the field name should be Specification1~Title, otherwise it will go into general

Specification1~SpecTitle
Add specification record to the product, this is useful to update specification in the futureColor~Red~1~Product InfoLetters and Numbers, avoid special characters. For example replace "&" by "and".
Ex: Material Stainless Steel, Warranty 3 years, Color Fire Engine Red, Brand AEM
Description~Value~1~Specification Category

See example: http://take.ms/KXhOn
http://take.ms/r37nX
78
YesOptionalOptional11/25/2014Specification 2


If you would like to give it a title other than general the field name should be Specification1~Title, otherwise it will go into general

Specification2~SpecTitle
Add specification record to the product, this is useful to update specification in the futureColor~Red~1~Product InfoLetters and Numbers, avoid special characters. For example replace "&" by "and".
Ex: Material Stainless Steel, Warranty 3 years, Color Fire Engine Red, Brand AEM
Description~Value~1~Specification Category
79
YesOptionalOptionalFeaturedWill show up on the Home Page under a Featured Products Block, with the words FEAT. as part of the imageCheck the box next to FeaturedChecked on product page under the Rules tab.
80
YesRequiredOptionalSupplierWhere the product is typcally purchased and shipped from.Turn14Letters and Numbers, avoid special characters. For example replace "&" by "and"MUST ASK CLIENT TO INPUT ACCURATE SUPPLIER

Do not use Shopping Cart Elite as supplier
81
YesOptionalOptionalRe-Order SupplierTypically the default supplier, but may be an alternateMay be left blank or the name of a supplier, with the same values as the supplierDo not use Shopping Cart Elite as supplier
82
YesOptionalOptionalWarehouseName of warehouse location. Some suppliers have multiple ship points, and the one you select is used for shipping charge calculations.Turn 14 California warehouseMay be left blank or the name of a supplier wharehouse, with the same values as the supplier
83
YesOptionalOptionalWorkflowIf you are the manufacture, the name of this particular workflowDash Kit assemblyName you assigned to a work flow. Letters and Numbers, avoid special characters. For example replace "&" by "and".
84
YesRecommendedOptional301 redirectAllow to import old URL for the product so you can instanty do a 301 redirect mapping
http://domain.com/urlextension (do not use www.)MUST EXIST IF YOU ARE MIGRATING OVER
85
YesOptionalOptionalHiddenDo you want to hide the product after upload from the backoffice and websiteyes or no (you can also use 0 or 1)
86
YesOptionalOptionalinternaluseIs this product used for internal purposes and show not be shown on the website only but show it on the backendyes or no (you can also use 0 or 1)
87
YesRequiredOptionalProcessing TimeHow may days until the product is shipped.5A number in the range of 1 to 20MUST ASK CLIENT
88
YesOptionalOptional1/4/2014CombinableCombinable in the box allows you to combine multiple items in the same box if you define it on the warehouse level0 or 1
89
YesOptionalOptional1/4/2014Consolidatable Consolidatable in the shipment allows you to combine a shipment together so it goes out as a bundle0 or 1
90
YesOptionalOptional8/29/2015pickup availableStore pickup option during checkout0 or 1
91
YesOptionalOptional5/22/2017Item ConditionThe item conditionRefubrished i-phoneNew = 0
Used = 1
Refurbished = 2
Damaged = 3
2MUST ASK CLIENT1
92
YesRequiredOptionalShipping TypeSelect if shipping charge is based on a fixed (flat)t rate or a live (dynamic) rate.flatEither "flat" or "dynamic"

NOTE: If you put FLAT than the optional fields will become required:

Shipping Ground Rate
Shipping 3-Day Air Rate
Shipping 2-Day Air Rate
Shipping Next-Day Air Rate
Shipping Inter. North America
Shipping Inter. South America
Shipping Inter. Europe
Shipping Inter. Africa
Shipping Inter. Asia
Shipping Inter. Oceania
Must ask client for details. DO NOT PUT FAKE INFORMATION
93
YesRequired (If Dynamic)OptionalShipping Carrier 1First shipping carrier name if shipping is dynamicUPSUPS or Fedex or USPS or others (Shipper name as defined under Backoffice > Shipping Providers)Must ask client for details. DO NOT PUT FAKE INFORMATION
94
YesOptionalOptionalShipping Carrier 2Second Shipping carrier name if shipping is dynamicFedExUPS or Fedex or USPS or others (Shipper name as defined under Backoffice > Shipping Providers)Must ask client for details. DO NOT PUT FAKE INFORMATION
95
YesOptionalOptionalShipping Carrier 3Third shipping carrier name if shipping is dynamicUSPSUPS or Fedex or USPS or others (Shipper name as defined under Backoffice > Shipping Providers)Must ask client for details. DO NOT PUT FAKE INFORMATION
96
OptionalOptionalShipping Carrier 4Third shipping carrier name if shipping is dynamicDHLUPS or Fedex or USPS or others (Shipper name as defined under Backoffice > Shipping Providers)Must ask client for details. DO NOT PUT FAKE INFORMATION
97
OptionalOptionalShipping Carrier 5Third shipping carrier name if shipping is dynamicFreight QuoteUPS or Fedex or USPS or others (Shipper name as defined under Backoffice > Shipping Providers)Must ask client for details. DO NOT PUT FAKE INFORMATION
98
YesRequired (if flat)OptionalallowgroundTurn on live rate for this shipping typeBlank or 1 to activateMust ask client for details. DO NOT PUT FAKE INFORMATION
99
YesRecommendedOptionalallow3dayTurn on live rate for this shipping typeBlank or 1 to activateMust ask client for details. DO NOT PUT FAKE INFORMATION
100
YesRecommendedOptionalallow2dayTurn on live rate for this shipping typeBlank or 1 to activateMust ask client for details. DO NOT PUT FAKE INFORMATION
Loading...