Closed

Properly format Excel spreadsheet to upload to eCrater

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: Data Entry, Data Processing, Excel

See more: copy format spreadsheet excel, convert word excel format, quickbooks invoice excel format, transfer picture excel format, word spreadsheet excel, excel format hours converted, upload txt excel format

About the Employer:
( 1 review ) london, United Kingdom

Project ID: #12784346

31 freelancers are bidding on average $53 for this job

mehedi276

Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see More

$100 USD in 4 days
(408 Reviews)
7.3
Ibrahim185

Hi, After reviewing the project description I know that I'm an excellent fit for this task.Let's discuss and start right now. Awaiting for your positive reply thanks.

$500 USD in 14 days
(402 Reviews)
6.8
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea More

$100 USD in 2 days
(159 Reviews)
6.3
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 100 works on Freelancer where major More

$30 USD in 1 day
(78 Reviews)
5.9
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$100 USD in 1 day
(93 Reviews)
5.9
serdaryalcin

Hi, Please share your file, and an example of the file we need to reach, or its documents, at the past I have completed some same projects. Best Regards

$48 USD in 1 day
(19 Reviews)
4.2
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Ma More

$30 USD in 1 day
(23 Reviews)
4.4
jiashahood

Hello, How are you, I hope you are doing great. Thanks for this wonderful opportunity. I am an experienced eCommerce store manager. I can convert your excel data feed file to ecarter compatible product's template. I More

$30 USD in 1 day
(18 Reviews)
4.3
Naumaan

Hi, please send me the file. All attributes will be organized in according to supplied instructions mentioned in the bulk file structure. Regards Nauman Pervez

$40 USD in 1 day
(9 Reviews)
3.6
muradeltaher

Hi There, I'm a Mechanical Engineer familiar with Microsoft Word, Microsoft Excel Google docs Spreadsheet, Wordpress, Magneto I Provide certain services : 1. Data Entry 2. Web Research 3. Social Media Ma More

$35 USD in 1 day
(10 Reviews)
3.2
mstbilkisakter

Hello, I have read your job description. I have proper experience about many data entry, research, internet research, market research, information research, data collection, data input, MS word, Excel sheet, power poi More

$25 USD in 1 day
(17 Reviews)
3.3
shahiddar

Hello, My name is shahid from Kashmir Over the last 7 years, I have worked for several clients. Joined Freelancer with over 7 years rich experience in the field.I have successfully completed more than 1000 projects in More

$111 USD in 0 days
(1 Review)
3.4
zaskock

Hello! I'm interested in your project, let's discuss the details? You can contact me via chat (usually on-line from 12:00 to 23:00 UTC+2) Can I have a spreadsheet that you need to convert or at least a few rows f More

$30 USD in 1 day
(5 Reviews)
3.1
anachirilov7

A proposal has not yet been provided

$60 USD in 1 day
(3 Reviews)
2.3
sheikDev

Hello, Im ready to help you on this. I will complete the work quickly and effectively. Please message me if you are interested. Thanks, Sheik

$25 USD in 1 day
(4 Reviews)
3.2
Smasum002

HI, FRIEND IF u r looking for a RELIABLE & HONEST HARD WORKER then it will be me,24/7 available for you. You can highly relay on me & your satisfaction is GUARANTEED by me. just reward me to prove my word by my work More

$25 USD in 1 day
(7 Reviews)
2.5
rumesh402

Hello, my name is Rumesh. I noticed your advertisement about the project and think I would make an excellent candidate for it.I read through the job details extremely careful and I'm absolutely confident that I can fo More

$15 USD in 0 days
(6 Reviews)
2.2
aditilundia7892

Hi I am an Microsoft Excel Expert and can work on data analysis, cleaning and sorting. I can use macros, slicer, power pivots, dynamic drop downs, data validation and customized functions to create the sheets accord More

$25 USD in 1 day
(1 Review)
0.8
coderspalace

Hello Sir, I own a team of highly talented and experienced expert in many aspects of the Computer world. We can get any work done to the expected results. A trial will convince u Sir. Looking forward to hearing from yo More

$20 USD in 3 days
(0 Reviews)
0.0
malaksamirvw

I'm bidding at min rate, not because I am least qualified, but because I need this assignment to increase my chances on freelancer, thanks.

$22 USD in 1 day
(0 Reviews)
0.0