Open

Properly format Excel spreadsheet to upload to eCrater

This project is ending in 3 days and has an average bid price of $57 USD.

Get free quotes for a project like this
Employer working
Project Budget
$10 - $30 USD
Total Bids
33
Project Description

I have an Excel spreadsheet of 900 inventory items in Excel 97-2003 format. I need to have it formatted correctly to upload to eCrater. The spreadsheet is complete, I just am having trouble getting it saved properly for upload. Our login and password information will be provided to the winning bidder. The point of this project is to have these items live on the eCrater store. Payment will be released once the inventory items are live.

The eCrater instructions are included below:

II. Bulk File Structure

You must prepare tab-delimited text file and save it using UTF-8 encoding. Each row of this file represents one product. Be careful not to include line breaks! Here is the sample bulk file: bulk.txt.

- title

- description

- local_cat_id

- global_cat_id

- image_url

- price

- weight

- taxable

- condition

- quantity

- shipping_us48

- shipping_alaska

- shipping_hawaii

- shipping_canada

Field's Definitions:

title - The name of the product.

description - Text describing the product.

local_cat_id - Local categories are the ones defined by you. They are valid only for your web store and their function is to organize your products in your web store. Please click on the link to find all local category id numbers:

Get All Local Category IDs

global_cat_id - Global categories are the ones defined by the eCRATER Team. They are valid for the main marketplace ([url removed, login to view]) which combines all seller's items.

Please click on the link to find all global category id numbers:

Get All Global Category IDs

image_url - The URL of an associated image for the product. Use only full-sized images. Do not use thumbnail images. If you do not have an image available, leave the attribute blank. Do not include company's logo images and images that say "Image not available". If you have multiple images separate each one by a comma.

price - The price for the product.

weight - in lbs. Weight is only needed if you are using weight based shipping method. If you are using flat rate or free shipping leave it blank.

taxable - Defines whether the item is taxable or not. Valid values are yes and no.

condition - Defines the condition of the product. Valid values are new and used.

quantity - The number of items available. You can leave it blank if you are sure that you can provide as many as needed.

shipping_us48 - The shipping price to US-Mainland. If you are using weight-based shipping leave it blank

shipping_alaska - The shipping price to Alaska. If you are not shipping to Alaska or you are using weight-based shipping leave it blank

shipping_hawaii - The shipping price to Hawaii. If you are not shipping to Hawaii or you are using weight-based shipping leave it blank

shipping_canada - The shipping price to Canada. If you are not shipping to Canada or you are using weight-based shipping leave it blank

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online