XOLogic Data Dictionary
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Item NumberItem NameItem CostImage Name
Base Item Number
Short DescriptionGTINIMAPMSRPWidthHeightLengthOrder MultipleOrder MinimumCategorySubcategoryAdditional Image FileVideoFileIn StockDiscontinuedBack Order Date{Additonal Data Label}FinishWarrantySome Fancy Label
2
1234-5678Red Thingama jig$100.0012345678.jpg1234
This is a very quality description of this red thingama jig.
1234567890$210.00$220.00505050ThingamaJig12345678-staged.jpghttps://youtu.be/abcde-fg
12345678-specsheet.pdf
50{data}Red
This item provides a manufacturer warranty…
3
1234-5679Blue Thingama jig$110.0012345679.jpg1234
This is a very quality description of this Blue thingama jig.
2345678901505050ThingamaJig12345679-staged.jpghttps://youtu.be/abcde-fg
12345679-specsheet.pdf
0012/3/2017{data}Blue
This item provides a manufacturer warranty…
4
5555.33-whWhite 33 inch Thingy$10.00
http://anotherbrand.com/images/5555.jpg
5555
This white 33 inch thingy will provide you with eactly what you need.
9876543210$20 $30 336100500Thingy300{data}BlackFancy data value
5
5555.33-blBlack 33 inch Thingy$10.00
http://anotherbrand.com/images/5555.jpg
5555
This black 33 inch thingy will provide you with that darker look that you need.
98765432112030336100500Thingy300{data}White
Fancy alternate data value
6
7
8
Your Spreadsheet should look similar to the above section, Color is not needed, It and the notes below should help explain what is going on in the spreadsheet.
9
The Basic Layout provided above can be sent if needed to the XO data team and they will convert it to the Advanced Layout to Process it.
Advanced Layout on the next tab is required if your doing your own Bulk Upload.
10
11
The first row can be labeled however you choose as long as its clear what the columns refer to so our XO data team can map them to our fields.
12
First Row Column Color Key:
13
Required Columns
14
Highly Recommended Columns but not required
15
Recommended Columns but not required
16
Vendor Categorization (Optional but Recommended)
17
Files,Videos,Additonal Images (Optional)
18
Availability Columns (Optional)
19
Additional Data (Optional)
20
21
Notes about the columns:
22
This is the sku and primary index for the productA brief name of the product, this will be included in the url, title, search results etc to help identify the product quickly.This should be a basic Distributor cost but can be a list price if needed, dristibutors will set discounts off of this to determine actual cogs. Ideally this price will change as a Manufacturer has a sell or changes the cost of the product. The price the Distributor will Sell for will be a markup of this cost. Many reports and tools will not work if this is not available, "Call for price" will display on the web without this, and the product will not be sellable without a salesreps help.Provide a URL to the image or the path and filename of files that are provided. Files can be dumped into the FTP account we have created for you. If a image is not provided for at least one product within the base group of the item, the items will not be searchable without directly specifying the SKUThis should be the same number across products that make sence to be grouped together when doing a search, variations will be displayed on the item detail page. At least one image should be provided per groupProvide a quality detailed description of the product hereSpecify your UPC Code or EAN numbers hereSpecify the minimum price your distributors are allowed to advertise this item for.Suggested Retail PriceSpecify the dimensions of the product hereSpecify the dimensions of the product hereSpecify the dimensions of the product hereThis represents the number of items that comes in each packThis represents the least amount that can be orderedSpecify the vendors Primary categorization of the product hereSpecify the vendors secondary categorization of the product here, More sub layer categorization columns can be added as neededsimilar to the primary image a url or filename refering to a file provided can be placed here, additonal columns can be added with a similar column header for every additonal image that is availableProvide a url to a supporting video here, additional columns with similar column headers can be provided for more videosProvide a url or a provided filename similar to images here. Files can be PDF's or any other downloadable format that would be useful to the end userSpecify the Qty available in stockset this to 1 if the product is no longer being made, when there is no more In stock amount and it is discontined the product will no longer be searchable unless specifying the SKU directly.When the product will next be available to purchase. Leave blank if it is available now. Any date format is acceptableThis is a template column, See examples to the Right. Provide as many extra columns of data as you have data available. Set the column header to be what you want as the label. Set the row values to be the data for each item next to that label. Blank fields on items will not show that label on the item. These extra columns will display on the item detail page as additional information. See all remaining columns to view examples columns of what could be provided. This is an example additional data columnThis is an example additional data columnThis is an example additional data column
23
24
General Spreadsheet Information:
25
All but the first three columns are optional and can be left blank or left out of the spreadsheet completely
26
The more data you provide the better
27
See the Advanced Layout if you wish to provide exact categorization, better sort and filters, recommended or included items, or image descriptions, icons, or swatches, etc..
28
Column Labels do not have to match the provided labels exactly however it should be obvious which column it is referring too.
29
30
Additional Notes:
31
as can be seen we will except essentially any data you have in whatever spreadsheet type format.
32
it is best to send us whatever you currently have to start with and then we can work with you to get more flushed out data.
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Basic Layout
Advanced Layout