Go to offeritem.com

Sell  /  Shopping Cart  /  My Account  /  Contact Us
Getting Started (updated on 3/24/11)
The order of your columns must be in the exact same order as in the sample files below. Errors will occur if the columns are rearranged or if they are deleted because our importer imports based on column count.
Download our sample file:
"findsit_test.xls" if using flat shipping costs.
-or-
"findsit_test_calculated.xls" if using U.S. Postal Service calculated shipping costs.
Follow The Mouse
Follow the mouse in the images for a detailed description of each action. Click on the images to enlarge.
Go to the "Bulk CSV Import" page by clicking Bulk CSV Import here.
Accepted Payment Methods
Update Now
Choose the payment method(s) that you would like to accept for this CSV upload and click "Update Now". You must accept at least one payment method prior to uploading your CSV file.
Uploading CSV Files Using Flat Rate Shipping
Download File Findsit_test.xls
If using flat shipping costs download "findsit_test.xls", you may also download this file from the top of this help page.
Click Category List
Click the "Category List" link, on the "Category List" page you will collect some required variables for your items (we recommend printing or bookmarking the "Category List" page).
Category List Page
Collect the numeric category value that best matches your items category. This value will be used in column "A" of your "findsit_test.xls" file and is required.
Condition List
Collect the numeric condition value that best matches your items condition. This value will be used in column "C" of your "findsit_test.xls" file and is required.
USA Shipping Method List
Collect the numeric USA shipping method value that best describes your items primary shipping method, this value specifies the shipping service used to ship the item. This value will be used in column "M" of your "findsit_test.xls" file and is required.
You may provide two additional shipping methods. If offering additional shipping methods, please ensure that each are unique. These additional shipping methods can be added to column "P" and/or "S" of your "findsit_test.xls" file and are optional.
Canada Shipping Method List
Collect the numeric Canada shipping method value that best describes your items Canada shipping method, this value specifies the shipping service used to ship the item to Canada. This value will be used in column "V" of your "findsit_test.xls" file and is optional.
Outside The USA & Canada Shipping Method List
Collect the numeric outside the USA & Canada shipping method value that best describes your items outside the USA & Canada shipping method, this value specifies the shipping service used to ship the item outside the USA & Canada. This value will be used in column "Y" of your "findsit_test.xls" file and is optional.
Color List
Collect the numeric color value that best describes your item's color. This value will be used in column "AA" of your "findsit_test.xls" file and is optional (updated on 2/19/11).
Findsit_test.xls Excel Example
Open the "findsit_test.xls" file in Microsoft Excel or a similar program. Each row will represent an item, each column will represent a value related to that item. Please note that row 1 will be ignored. Insert your information by starting with row 2 and work your way down, example: row 2, 3, 4 etc. Please remember to keep the size of your file below 20 MB. Below we will describe each column in detail.
* Required information
! Might require information
*"Column A: Category" This field is required. Must be numeric. Please use our category list as reference.
"Column B: Galley Image" This field is not required but recommended. This field must be in a URL format, example: http://www.your_image.com/pic_to_use.jpg and must be a maximum 128 characters long. Your images extension must be JPEG, JPG, PNG or GIF.
*"Column C: Condition" This field is required. Must be numeric. Please use our condition list as reference.
"Column D: UPC" Must be a numeric value. This field is not required.
*"Column E: Title" This field is required. Maximum 64 characters long. No HTML.
*"Column F: Description" This field is required. Basic HTML tags allowed.
"Column G: Return Policy" This field is not required but recommended. No HTML.
"Column H: Checkout Instructions" This field is not required but recommended. No HTML.
*"Column I: Quantity" This field is required. Must be a numeric value.
*"Column J: Price" This field is required. Must be a decimal (.) value, please leave out commas (,) example $1,000.00 would be 1000.00.
*"Column K: Shipping cost (United States)" This field is required. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping.
!"Column L: Shipping cost for each addition item (United States)" This field is only required if your quantity is greater than 1. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping. If your quantity equals 1 leave this field empty.
*"Column M: Shipping method (United States)" This field is required. Must be numeric. Please use our USA shipping method list as reference.
"Column N: Shipping cost (United States) 2" This field is not required. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping. Opt out by leaving this field empty.
!"Column O: Shipping cost for each addition item (United States) 2" This field is only required if your quantity is greater than 1 and column N contains a value. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping. If your quantity equals 1 leave this field empty. Opt out by leaving this field empty.
!"Column P: Shipping method (United States) 2" This field is only required if column N contains a value. Must be numeric. Please use our USA shipping method list as reference.
"Column Q: Shipping cost (United States) 3" This field is not required. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping. Opt out by leaving this field empty.
!"Column R: Shipping cost for each addition item (United States) 3" This field is only required if your quantity is greater than 1 and column Q contains a value. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping. If your quantity equals 1 leave this field empty. Opt out by leaving this field empty.
!"Column S: Shipping method (United States) 3" This field is only required if column Q contains a value. Must be numeric. Please use our USA shipping method list as reference.
"Column T: Shipping cost (Canada)" This field is not required. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping. Opt out by leaving this field empty.
!"Column U: Shipping cost for each additional item (Canada)" This field is only required if your quantity is greater than 1 and column T contains a value. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping. Opt out by leaving this field empty.
!"Column V: Shipping method (Canada)" This field is only required if column T contains a value. Must be numeric. Please use our Canada shipping method list as reference.
"Column W: Shipping cost (outside the USA & Canada)" This field is not required. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping. Opt out by leaving this field empty.
!"Column X: Shipping cost for each additional item (outside the USA & Canada)" This field is only required if your quantity is greater than 1 and column W contains a value. Must be a decimal (.) value, please leave out commas (,). Please add 0 for free shipping. Opt out by leaving this field empty.
!"Column Y: Shipping method (outside the USA & Canada)" This field is only required if column W contains a value. Must be numeric. Please use our outside the USA & Canada shipping method list as reference.
"Column Z: Brand" This field is not required. Maximum 30 characters long. No HTML. Please type the brand name exactly as the brand owner would (updated on 2/19/11).
"Column AA: Color" This field is not required. Must be numeric. Please use our color list as reference (updated on 2/19/11).
"Column AB: MPN" This field is not required. This is the manufacturer's part number (updated on 2/19/11).
"Column AC: ISBN" This field is not required. This field is intended for books (updated on 2/19/11).
Findsit_test.xls Save As
When you have finished your spreadsheet you will need to save it as a "CSV (comma delimited)" file. If using Microsoft Excel save by clicking "File or the Office logo" and then by clicking "Save As".
Findsit_test.xls Save As Delimited
The name of your file can remain Findsit_test or you can change it to something else. Your "Save as type:" must be "CSV (comma delimited)", by default this is set to something other than CSV (comma delimited). When finished click the "Save" button.
Findsit_test.xls Saved
Your saved file should now look like the image above.
Findsit_test.xls Saved
We will now proceed by uploading our saved CSV file to Offeritem.com, click on the "Bulk CSV Import (items with flat rate shipping)" link located on the "Bulk CSV Import" page, you may access this page by clicking Bulk CSV Payments Page here.
Upload Findsit_test.csv
Upload your saved CSV file by clicking the "Browse" button on the "Bulk CSV Import (items with flat rate shipping)" page, you may access this page by clicking Bulk CSV Import Page here.
Select Findsit_test.csv
Find your file, select it and click the "Open" button.
Selected Findsit_test.csv
Now click the "Upload File" button.
Error Findsit_test.csv
If your CSV file contains errors, a detailed description of each error will be displayed on your screen. "Line:" will refer to the row causing the error(s), "Item:" will refer to the title of the item that contains the error(s). In some cases the "Item:" field may be unavailable. In the "Error:" field a detailed description will be provided, please read carefully. We will insert items without errors and skip items that contain errors. Items that are inserted will be displayed in the "items added to queue" section. If your file contains errors and you cannot figure out how to resolve them, please contact us for assistance.
Success Findsit_test.csv
A successful upload will look something like the above image. Please see the "items added to queue" section. Please note that it may take us up to 24 hours to import your items after they have been added to queue. Thank you for taking the time to read this information and happy uploading.
Uploading CSV Files Using USPS Calculated Shipping
Note: Shipping rates are calculated as "Post Office Price". Extra services (example: delivery confrimation or insurance) are not being calculated. If you plan to offer extra services, please include these costs in your items price.
Download File Findsit_test_calculated.xls
If using USPS calculated shipping costs download "findsit_test_calculated.xls", you may also download this file from the top of this help page.
Click Calculated Category List
Click the "Calculated Category List" link, on the "Calculated Category List" page you will collect some required variables for your items (we recommend printing or bookmarking the "Calculated Category List" page).
Calculated Category List Page
Collect the numeric category value that best matches your items category. This value will be used in column "A" of your "findsit_test_calculated.xls" file and is required.
Condition List
Collect the numeric condition value that best matches your items condition. This value will be used in column "C" of your "findsit_test_calculated.xls" file and is required.
Below we will try to describe each USPS calculated shipping field in detail. To better understand how the United States Postal Service calculates shipping rates, please use our USPS Shipping Calculator.
USA Calculated Shipping Method List
Collect the numeric USA Calculated shipping method value that best describes your items primary shipping method, this value specifies the shipping service used to ship the item. This value will be used in column "K" of your "findsit_test_calculated.xls" file and is required. Please see the maximum weight limit for each shipping service.
You may provide two additional shipping methods. If offering additional shipping methods, please ensure that each are unique. These additional shipping methods can be added to column "Q" and/or "W" of your "findsit_test_calculated.xls" file and are optional.
USA Calculated Shipping Package Size List
Column "L" requires a package size value, information on obtaining this value can be found on the "Calculated Category List" under the heading "USA Calculated Shipping Package Size List".
Column "R" requires a package size value if column "Q" contains a value. Column "X" requires a package size value if column "W" contains a value.
If your package size is "Large Rectangular" or "Large NonRectangular" column "M" requires a value. Your package dimensions must be in the following format "LengthXHeightXWidth" for "Large Rectangular" and "LengthXHeightXWidthXGirth" for "Large NonRectangular", replace Length, Height, Width and Girth with decimal or numeric values.
Column "S" requires package dimensions if column "R" contains the value "Large Rectangular" or "Large NonRectangular". Column "Y" requires package dimensions if column "X" contains the value "Large Rectangular" or "Large NonRectangular".
Calculated Canada Shipping Method List
Collect the numeric Canada shipping method value that best describes your items Canada shipping method, this value specifies the shipping service used to ship the item to Canada. This value will be used in column "AC" of your "findsit_test_calculated.xls" file and is optional. Please see the maximum weight limit for each shipping service.
Calculated Outside The USA & Canada Shipping Method List
Collect the numeric outside the USA & Canada shipping method value that best describes your items outside the USA & Canada shipping method, this value specifies the shipping service used to ship the item outside the USA & Canada. This value will be used in column "AG" of your "findsit_test_calculated.xls" file and is optional. Please see the maximum weight limit for each shipping service.
Color List
Collect the numeric color value that best describes your item's color. This value will be used in column "AJ" of your "findsit_test_calculated.xls" file and is optional (updated on 2/19/11).
Findsit_test_calculated_example.jpg Excel Example
Open the "findsit_test_calculated.xls" file in Microsoft Excel or a similar program. Each row will represent an item, each column will represent a value related to that item. Please note that row 1 will be ignored. Insert your information by starting with row 2 and work your way down, example: row 2, 3, 4 etc. Please remember to keep the size of your file below 20 MB. Below we will describe each column in detail.
* Required information
! Might require information
*"Column A: Category" This field is required. Must be numeric. Please use our calculated category list as reference.
"Column B: Galley Image" This field is not required but recommended. This field must be in a URL format, example: http://www.your_image.com/pic_to_use.jpg and must be a maximum 128 characters long. Your images extension must be JPEG, JPG, PNG or GIF.
*"Column C: Condition" This field is required. Must be numeric. Please use our calculated condition list as reference.
"Column D: UPC" Must be a numeric value. This field is not required.
*"Column E: Title" This field is required. Maximum 64 characters long. No HTML.
*"Column F: Description" This field is required. Basic HTML tags allowed.
"Column G: Return Policy" This field is not required but recommended. No HTML.
"Column H: Checkout Instructions" This field is not required but recommended. No HTML.
*"Column I: Quantity" This field is required. Must be a numeric value.
*"Column J: Price" This field is required. Must be a decimal (.) value, please leave out commas (,) example $1,000.00 would be 1000.00.
*"Column K: Shipping method (United States)" This field is required. Must be numeric. Please use our USA calculated shipping method list as reference.
*"Column L: Shipping package size (United States)" This field is required. Please use our USA calculated package size list as reference.
!"Column M: Shipping dimensions (United States)" This field is only required if column L contains the value "Large Rectangular" or "Large NonRectangular". "LengthXHeightXWidth" for "Large Rectangular" and "LengthXHeightXWidthXGirth" for "Large NonRectangular", replace Length, Height, Width and Girth with decimal or numeric values, example: 5X5X2.5 and 5X5X2.5X3. Please use our USA calculated shipping package size list as reference.
*"Column N: Shipping weight pounds (United States)" This field is required. Must be a numeric value. If your package weights less than 1 pound enter 0.
*"Column O: Shipping weight ounces (United States)" This field is required. Must be a numeric or decimal value. You may enter 0 in this field if column N is equal to or greater than 1 pound.
*"Column P: Shipping zip code (United States)" This field is required. Must be numeric and contain only digits. This is the zip code that the item will ship from.
"Column Q: Shipping method (United States) 2" This field is not required. Must be numeric. Please use our USA calculated shipping method list as reference.
!"Column R: Shipping package size (United States) 2" This field is only required if column Q contains a value. Please use our USA calculated package size list as reference.
!"Column S: Shipping dimensions (United States) 2" This field is only required if column R contains the value "Large Rectangular" or "Large NonRectangular". "LengthXHeightXWidth" for "Large Rectangular" and "LengthXHeightXWidthXGirth" for "Large NonRectangular", replace Length, Height, Width and Girth with decimal or numeric values, example: 5X5X2.5 and 5X5X2.5X3. Please use our USA calculated shipping package size list as reference.
!"Column T: Shipping weight pounds (United States) 2" This field is only required if column Q contains a value. Must be a numeric value. If your package weights less than 1 pound enter 0.
!"Column U: Shipping weight ounces (United States) 2" This field is only required if column Q contains a value. Must be a numeric or decimal value. You may enter 0 in this field if column T is equal to or greater than 1 pound.
!"Column V: Shipping zip code (United States) 2" This field is only required if column Q contains a value. Must be numeric and contain only digits. This is the zip code that the item will ship from.
"Column W: Shipping method (United States) 3" This field is not required. Must be numeric. Please use our USA calculated shipping method list as reference.
!"Column X: Shipping package size (United States) 3" This field is only required if column W contains a value. Please use our USA calculated package size list as reference.
!"Column Y: Shipping dimensions (United States) 3" This field is only required if column X contains the value "Large Rectangular" or "Large NonRectangular". "LengthXHeightXWidth" for "Large Rectangular" and "LengthXHeightXWidthXGirth" for "Large NonRectangular", replace Length, Height, Width and Girth with decimal or numeric values, example: 5X5X2.5 and 5X5X2.5X3. Please use our USA calculated shipping package size list as reference.
!"Column Z: Shipping weight pounds (United States) 3" This field is only required if column W contains a value. Must be a numeric value. If your package weights less than 1 pound enter 0.
!"Column AA: Shipping weight ounces (United States) 3" This field is only required if column W contains a value. Must be a numeric or decimal value. You may enter 0 in this field if column Z is equal to or greater than 1 pound.
!"Column AB: Shipping zip code (United States) 3" This field is only required if column W contains a value. Must be numeric and contain only digits. This is the zip code that the item will ship from.
"Column AC: Shipping method (Canada)" This field is not required. Must be numeric. Please use our Canada calculated shipping method list as reference.
!"Column AD: Shipping weight pounds (Canada)" This field is only required if column AC contains a value. Must be a numeric value. If your package weights less than 1 pound enter 0.
!"Column AE: Shipping weight ounces (Canada)" This field is only required if column AC contains a value. Must be a numeric or decimal value. You may enter 0 in this field if column AD is equal to or greater than 1 pound.
"Column AF: Shipping method (outside the USA & Canada)" This field is not required. Must be numeric. Please use our outside the USA & Canada calculated shipping method list as reference.
!"Column AG: Shipping weight pounds (outside the USA & Canada)" This field is only required if column AF contains a value. Must be a numeric value. If your package weights less than 1 pound enter 0.
!"Column AH: Shipping weight ounces (outside the USA & Canada)" This field is only required if column AF contains a value. Must be a numeric or decimal value. You may enter 0 in this field if column AG is equal to or greater than 1 pound.
"Column AI: Brand" This field is not required. Maximum 30 characters long. No HTML. Please type the brand name exactly as the brand owner would (updated on 2/19/11).
"Column AJ: Color" This field is not required. Must be numeric. Please use our color list as reference (updated on 2/19/11).
"Column AK: MPN" This field is not required. This is the manufacturer's part number (updated on 2/19/11).
"Column AL: ISBN" This field is not required. This field is intended for books (updated on 2/19/11).
Findsit_test_calculated.xls Save As
When you have finished your spreadsheet you will need to save it as a "CSV (comma delimited)" file. If using Microsoft Excel save by clicking "File or the Office logo" and then by clicking "Save As".
Findsit_test_calculated.xls Save As Delimited
The name of your file can remain Findsit_test_calculated or you can change it to something else. Your "Save as type:" must be "CSV (comma delimited)", by default this is set to something other than CSV (comma delimited). When finished click the "Save" button.
Findsit_test_calculated.xls Saved
Your saved file should now look like the image above.
Findsit_test_calculated.xls Saved
We will now proceed by uploading our saved CSV file to Offeritem.com, click on the "Bulk CSV Import (items with calculated shipping)" link located on the "Bulk CSV Import" page, you may access this page by clicking Bulk CSV Calculated Import Page here.
Upload Findsit_test_calculated.csv
Upload your saved CSV file by clicking the "Browse" button on the "Bulk CSV Import (items with calculated shipping)" page, you may access this page by clicking Bulk CSV Calculated Import Page here.
Select Findsit_test_calculated.csv
Find your file, select it and click the "Open" button.
Selected Findsit_test_calculated.csv
Now click the "Upload File" button.
Error Findsit_test_calculated.csv
If your CSV file contains errors, a detailed description of each error will be displayed on your screen. "Line:" will refer to the row causing the error(s), "Item:" will refer to the title of the item that contains the error(s). In some cases the "Item:" field may be unavailable. In the "Error:" field a detailed description will be provided, please read carefully. We will insert items without errors and skip items that contain errors. Items that are inserted will be displayed in the "items added to queue" section. If your file contains errors and you cannot figure out how to resolve them, please contact us for assistance.
Success Findsit_test_calculated.csv
A successful upload will look something like the above image. Please see the "items added to queue" section. Please note that it may take us up to 24 hours to import your items after they have been added to queue. Thank you for taking the time to read this information and happy uploading.

Copyright © 2009 - 2017 Offeritem All Rights Reserved

Offeritem - del.icio.usdel.icio.us   Offeritem - DiggDigg   Offeritem - Yahoo myWebYahoo myWeb  Offeritem - SpurlSpurl   Offeritem - FurlFurl   Offeritem - AskAsk   Offeritem - SquidooSquidoo  
Offeritem - SimpySimpy   Offeritem - RedditReddit   Offeritem - ma.gnoliama.gnolia   Offeritem - Google BookmarkGoogle Bookmark   RSS FeedsRSS
Offeritem Supports the following web browsers: Offeritem - Supports Internet Explorer  Offeritem - Supports Safari  Offeritem - Supports Mozilla Firefox  Offeritem - Supports Netscape Navigator