Compare: Amazon Craigslist eBay Google Shopping
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.
  1. The file must be either in .xls or .xlsx format.
  2. 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.
  3. You must include all the fields specified as "required" from the below table.
  4. You must specify a UNIQUEID for each product. UNIQUEID is used to identify individual products. In future, you can update the product information by specifying the same UNIQUEID for the same product and uploading the file again.
  5. We only import first workbook of your spreadsheet. Make sure you have listings in 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 sub categories apart from the categories mentioned above, then go to the TrueGether UI 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 sub categories, 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 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 screen to figure out if 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 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 (upto 500000 characters) Yes The Body Building Guide to a perfect body
DOMESTICSHIPPINGCOST1 to DOMESTICSHIPPINGCOST3 Domestic shipping cost (upto 2 decimal places). If 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 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 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 chose 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 the 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 upto 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 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 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 (upto 2 decimal places). If 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
MPN MPN or SKU of the item No ISBN123456
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
LISTPRICE MRP of your item (upto 2 decimal digits) No 80
PRICE Price of your item (upto 2 decimal digits) Yes 50
PRIVATELISTING If you do not want to show the item in recently sold items on 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 (upto 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
© 2016 PixalSoft. All Rights Reserved