Home > Help & Contact >
How do we import items from an existing inventory (Excel) file?
You can keep your inventory in a spreadsheet which can be uploaded to TrueGether.
Follow the guidelines below to create and upload an inventory file successfully.
- The file must be either in .xls or .xlsx format.
- You must use the format specified in sample.xls (Do not change the first two header rows). You can download the sample.xls from this page.
- You must include all the fields specified as "required" from the below table.
- You must specify a UNIQUEID for each product. UNIQUEID is used to identify individual products. In the future, you can update the product information by specifying the same UNIQUEID for the same product and uploading the file again.
- We only import the first workbook of your spreadsheet. Make sure you have listings in the first workbook.
Sample Inventory file:sample.xls
Here are all possible TrueGether column names.
Column Name | Data expected | Required? | Example data |
---|---|---|---|
ASIN | The Amazon Standard Identification Number. If you have subscribed to Amazon as a TrueGether Managed Marketplace, you can export your listings to Amazon. In this case you must enter ASIN, else your items will not be exported to Amazon. | No | B00J4TWRJA |
BRANDNAME | The brand of the item | No | Simon & Schuster |
BULKPRICE | Bulk Price per piece. Refer to the PRICE column above for the supported currencies | No | 45 |
BULKQUANTITY | Minimum order quantity for Bulk Price | No | 3 |
CATEGORY | The broad categories must be one of the following: Antiques Automobiles Baby Books Business & Industrial Cameras & Photo Cell Phones & Accessories Clothing, Shoes & Accessories Computers/Tablets & Networking Consumer Electronics Crafts Entertainment Memorabilia Gift Cards & Coupons Health & Beauty Home & Garden Jewelry & Watches Music Musical Instruments & Gear Pet Supplies Real Estate Specialty Services Sporting Goods Tickets & Experiences Toys & Hobbies Travel Video Games & Consoles If you want to post your item in any of the subcategories apart from the categories mentioned above, then go to the TrueGether UI ( Create a listing > Marketplaces tab > Navigate to the desired category ) and see the entire hierarchy of the category. For eg. Books > Catalogs > Aquaculture | Yes | Books > Catalogs > Agriculture |
CONDITION | Condition of your item. If you are specifying a broad category, it must be one of the following: New Pre-Owned Manufacturer refurbished If you want to post your item in any of the subcategories, the condition must be one of the following: Brand New Like New Very Good Good Acceptable Used Manufacturer refurbished New For parts or not working New with tags Pre-owned New without tags New without box New with box New other (see details) Seller refurbished New with defects Remanufactured Retread Damaged Certified Pre-Owned You can go to the TrueGether Listing create a screen to figure out which conditions are valid for your listing category. | Yes (It may be optional for some of the categories. You can go to the TrueGether Listing create a screen to figure out if the condition is required or optional for your listing category.) | New |
Country of Manufacture Example of Category-specific attributes | You can add a separate column for each category-specific attribute. For example, if the category of the listing is Books & Magazines > Catalogs > Agriculture. The category-specific attributes as per the UI in TrueGether is Country of Manufacture. So add 1 separate column in your excel sheet with column name exactly matching the UI as Country of Manufacture | Yes or No (Use TrueGether Listing create screen to know if the category-specific attribute is required or not) | Australia |
CURRENCY | The supported currencies are: AUD CAD EUR GBP JPY USD NZD HKD SGD SEK DKK PLN NOK HUF CZK ILS MXN BRL INR MYR PHP TWD THB TRY RUB The default currency is based on your location. If your currency is different from the currencies mentioned above, then the price will be considered in USD. | No | USD |
DESCRIPTION | Description of your item (up to 500000 characters) | Yes | The Body Building Guide to a perfect body |
DOMESTICSHIPPINGCOST1 to DOMESTICSHIPPINGCOST3 | Domestic shipping cost (up to 2 decimal places). If the domestic shipping cost is specified, then you must specify the Domestic Shipping service for the item. Refer to the PRICE column above for the supported currencies | No | 5 |
DOMESTICSHIPPINGSERVICE1 to DOMESTICSHIPPINGSERVICE3 | Shipping Service for domestic shipping. It must be one of the following: If your listing location is the US: USPS Parcel Select (2 to 9 business days) USPS Media Mail (2 to 8 business days) USPS First Class Package (2 to 5 business days) USPS Priority Mail (2 to 3 business days) USPS Priority Mail Express (1 business day) UPS Ground (1 to 5 business days) UPS 3 Day Select (3 business days) UPS 2nd Day Air (2 business days) UPS Next Day Air (1 business day) FedEx Ground FedEx Express Saver (1 to 3 business days) FedEx 2Day (1 to 2 business days) FedEx Priority Overnight (1 business day) Other (see listing description) Free Local Pickup If your listing location is the UK: Collect+ Economy Tracked (3 to 5 working days) Hermes Tracked (3 to 5 working days) Royal Mail 2nd Class (2 to 3 working days) Royal Mail 2nd Class Signed For (2 to 3 working days) Royal Mail Tracked 48 (2 to 3 working days) Royal Mail 48 (2 to 3 working days) Other Courier 3 days (3 working days) Other Courier 5 days (5 working days) Other Courier (3 to 5 working days) Other Courier 3-5 days (3 to 5 working days) Royal Mail 1st Class (1 working day) Royal Mail 1st Class Signed For (1 working day) Royal Mail Tracked 24 Royal Mail 24 (1 working day) Collect + Standard (2 working days) Parcelforce 48 (1 to 2 working days) Other 48 Hour Courier (1 to 2 working days) Royal Mail Special Delivery (TM) 1:00 pm Royal Mail Special Delivery (TM) 9:00 am (1 working day) Parcelforce 24 (1 working day) Other 24 Hour Courier (1 working day) Other (see listing description) Free Local Pickup If your listing location is CA: Economy Shipping (1 to 15 business days) Canada Post Lettermail (2 to 6 business days) FedEx Economy (2 to 4 business days) Standard Shipping (1 to 10 business days) Canada Post Regular Parcel (2 to 10 business days) UPS Standard Canada (1 to 10 business days) Expedited shipping (1 to 5 business days) Canada Post Expedited Parcel (1 to 7 business days) Express Shipping (1 to 2 business days) Canada Post Xpresspost (1 to 3 business days) Canada Post Priority (1 to 2 business days) UPS Expedited Canada (2 business days) UPS Express Canada (1 business day) UPS Express Saver Canada (1 business day) FedEx 2 Day (2 to 3 business days) FedEx Priority Overnight (1 to 2 business days) FedEx First Overnight (1 business day) If your listing location is AU: eBay Australia Post Flat Rate 500g Satchel (2 to 6 business days) eBay Australia Post Flat Rate 500g Satchel + Signature (2 to 6 business days) eBay Australia Post Flat Rate 3kg Satchel (2 to 6 business days) eBay Australia Post Flat Rate 3kg Satchel + Signature (2 to 6 business days) Australia Post Flat Rate BX1 Small Box (1 to 6 business days) eBay Australia Post Flat Rate Small (Bx1) Box + Signature (2 to 6 business days) Australia Post Flat Rate BX2 Medium Box (1 to 6 business days) eBay Australia Post Flat Rate Medium (Bx2) Box + Signature (2 to 6 business days) Australia Post Flat Rate BX4 Large Box (1 to 6 business days) eBay Australia Post Flat Rate Large (Bx4) Box + Signature (2 to 6 business days) eBay Fastway Road Express (1 to 12 business days) Standard delivery (1 to 6 business days) Standard Delivery - Registered (1 to 6 business days) Australia Post Parcel Post Parcel (2 to 6 business days) Australia Post Regular Parcel + Tracking (2 to 6 business days) Australia Post Parcel Post Parcel + Signature (2 to 6 business days) Australia Post Prepaid Parcel Post 500g Satchel (2 to 6 business days) Australia Post Prepaid Parcel Post 3kg Satchel (2 to 6 business days) Australia Post Prepaid Parcel Post 5kg Satchel (2 to 6 business days) Australia Post Regular Parcel Registered (2 to 6 business days) Australia Post Prepaid Parcel Post 500g Satchel + Signature (2 to 6 business days) Australia Post Prepaid Parcel Post 3kg Satchel + Signature (2 to 6 business days) Australia Post Prepaid Parcel Post 5kg Satchel + Signature (2 to 6 business days) Express delivery (1 to 3 business days) Australia Post Express Post Parcel (1 to 3 business days) Australia Post Express Post Parcel + Signature (1 to 3 business days) Australia Post Express Post 500g Satchel (1 to 3 business days) Australia Post Express Post 3kg Satchel (1 to 3 business days) Australia Post Express Post 5kg Satchel (1 to 3 business days) Australia Post Express Post 500g Satchel + Signature (1 to 3 business days) Australia Post Express Post 3kg Satchel + Signature (1 to 3 business days) Australia Post Express Post 5kg Satchel + Signature (1 to 3 business days) DHL (1 to 3 business days) Fastway Couriers (1 to 3 business days) Star Track Express (1 to 3 business days) TNT (1 to 3 business days) Toll Consumer Delivery (1 to 3 business days) Courier (1 to 3 business days) If your listing location is IN: Flat Rate Courier - Delivery anywhere in India Local Courier - Delivery within sellers city National Courier - Delivery outside sellers city Surface Delivery - Nationwide land transport delivery If your listing location is Outside US/UK/CA/AU/IN: Economy Shipping Express Shipping Other (see listing description) | No | USPS Parcel Select (2 to 9 business days) |
DOMESTICSHIPPINGCOSTAI1 to DOMESTICSHIPPINGCOSTAI3 | The domestic shipping cost for each additional item. Refer to the PRICE column above for the supported currencies | No | 4 |
EXPORTTOEBAY | If you have subscribed to eBay as a TrueGether Managed Marketplace, you can export your listings to eBay. In this case, you must choose a leaf level subcategory, else your items will not be exported to eBay. | No | Yes |
EXPORTTOAMAZON | If you have subscribed to Amazon as a TrueGether Managed Marketplace, you can export your listings to Amazon. In this case, you must enter ASIN, else your items will not be exported to Amazon. | No | Yes |
FREEDOMESTICSHIPPING | If item is available for free shipping or not (Specify Yes/No) | No | Yes |
FREEINTERNATIONALSHIPPING | If the item is available for free international shipping or not (Specify Yes/No) | No | Yes |
GTIN | The UPC/EAN/GTIN of the item | No | GTIN1234 |
IMAGE1 to IMAGE12 | Excel file supports uploading up to 12 images. Each image column should give a full URL (e.g., http://www.truegether.com/images/myimage.jpg) to an image for this item. | No | http://www.truegether.com/myimage.jpg |
INTERNATIONALSHIPPINGCOUNTRY1 to INTERNATIONALSHIPPINGCOUNTR3 | The country/region to which you want to ship your item. It must be one of the following: USA Canada Europe Asia Mexico N. and S. America Australia Japan United Kingdom Germany Worldwide Ireland European Union France Taiwan Hong Kong New Zealand China Brazil Russian Federation Belgium Denmark Greece Italy Spain | No | Europe |
INTERNATIONALSHIPPINGSERVICE1 to INTERNATIONALSHIPPINGSERVICE3 | The shipping service to be used for items to be shipped internationally. It must be one of the following: If your listing location is the US: USPS First-Class Mail International USPS Priority Mail International USPS Priority Mail Express International UPS Standard to Canada UPS Worldwide Saver UPS Worldwide Expedited UPS Worldwide Express UPS Worldwide Express Plus FedEx Ground International to Canada FedEx International Economy FedEx International Priority Others (See Listing Description) If your listing location is the UK: Royal Mail International Standard (Small Packets) Royal Mail International Tracked Royal Mail International Economy Royal Mail International Signed Royal Mail HM Forces Mail Parcelforce Global Express Parcelforce Global Priority Parcelforce Global Value Parcelforce Global Economy (Not available for destinations in Europe) Economy Int'l Postage Standard Int'l Postage Express Int'l Postage International Tracked Postage Others (See Listing Description) If your listing location is CA: Canada Post USA Letter-post Canada Post Light Packet USA Canada Post Small Packets - USA - Air Canada Post Tracked Packet - USA Canada Post Expedited Parcel - USA Canada Post Xpresspost - USA Canada Post International Letter-post Canada Post Light Packet International Small Packets - International - Ground Small Packets - International - Air Canada Post Tracked Packet - International Canada Post International Parcel - Surface Canada Post International Parcel - Air Canada Post Xpresspost - International Canada Post Priority Worldwide UPS Express United States UPS Expedited United States UPS 3 Day Select United States UPS Standard United States UPS Worldwide Express UPS Worldwide Expedited FedEx International Economy - USA FedEx International Priority - USA FedEx International Economy - International FedEx International Priority - International Standard Int'l Shipping Expedited Int'l Shipping If your listing location is AU: Standard International Flat Rate Postage AusPost Air Mail Parcel AusPost Registered Post International Parcel AusPost Registered Post International Padded Bag 500g AusPost Registered Post International Padded Bag 1kg AusPost Sea Mail Parcel Express International Flat Rate Postage AusPost Express Post International Parcel AusPost PrePaid Express Post International Envelope C5 AusPost PrePaid Express Post International Envelope B4 AusPost PrePaid Express Post International Satchel 2Kg AusPost PrePaid Express Post International Satchel 3Kg AusPost PrePaid Express Post International Box 5Kg AusPost PrePaid Express Post International Box 10Kg AusPost PrePaid Express Post International Box 20Kg AusPost Express Courier International RU Tracked Packet from China If your listing location is IN: International - Standard International - Expedited International - Other If your listing location is Other than US/UK/CA/AU/IN: UPS FedEx DHL Economy Shipping From Outside US (11 to 23 business days) Priority Shipping From Outside US (5 to 10 business days) Express Shipping From Outside US (4 to 7 business days) Other (see listing description) | No | USPS First Class Mail International |
INTERNATIONALSHIPPINGCOSTAI1 to INTERNATIONALSHIPPINGCOSTAI3 | The additional international shipping cost for each additional item. Refer to the PRICE column above for the supported currencies | No | 24 |
INTERNATIONALSHIPPINGCOST1 to INTERNATIONALSHIPPINGCOST3 | International shipping cost (up to 2 decimal places). If the international shipping cost is specified, then you must specify the International Shipping Country and the International Shipping Service as well. Refer to the PRICE column above for the supported currencies | No | 25 |
LISTPRICE | MRP of your item (up to 2 decimal digits) | No | 80 |
MPN | MPN or SKU of the item | No | ISBN123456 |
NEWIMAGES | If changing images or uploading the first time, (Specify Yes/No) | No | Y |
PICKUPONLY | If the item is available for local pickup only (Specify Yes/No). If Local PickUp only is specified, then do not specify any domestic or international shipping options. You must specify at least one option i.e either Local Pick Up or Free Shipping or Paid Shipping. | No | No |
PRICE | Price of your item (up to 2 decimal digits) | Yes | 50 |
PRIVATELISTING | If you do not want to show the item in recently sold items on the home page or items sold by your network in MyProfile Page. (Specify Yes/No) | No | No |
QUANTITY | The number of items you want to sell | Yes | 10 |
RETURNSALLOWED | If you accept returns (Specify Yes/No) | No | Yes |
TITLE | The title of your item (up to 80 characters) | Yes | The Body Building Guide |
UNIQUEID | A unique number or string to identify your item, so if you upload your file multiple times, items with identical ids will update (rather than re-add). | Yes | TGUSSELLERNAME123 |