Excel File conversion data from BigCommerce format to Springboard Retail format

Status: Closed
Prize: $100
Entries Received: 11
Winner: elqueabandona

Winner

Contest Brief

Hello all. We are in the process of uploading our Big Commerce retail store products to Springboard Retail. We have imported most of our product details successfully using Excel, however we are still having some issues with uploading parts of the store and matching columns as these two excel files are extremely different. One specifically giving us trouble is the product categories. We are not that familiar with changing one format or matching the columns to another. We are seeking someone who knows Excel formulas and or shortcuts to get these two files to match up so we can upload everything into Springboard. For the right person, it will probably take only minutes.

What we need is the "catagory" column "AB" from the Big Commerce file to be imported into the springboard file in Column "BG" named "Big commerce Categories" They must match and be cross referenced using the items numbers matching from springboard column "A" named "Item Number" with the Big Commerce file column "E" named "product code/sku" The new catagory name will look like "Medical/Medical Bags | Pouches;" It must include a semicolon at the end not currently present at the end of each value.

The end result is for us to have a complete "springboard" file fully populated with a catagory value for each line matching exactly to the product/sku in the big commerce file.

Recommended Skills

Excel

Winner

Post a Contest Like This

Employer Feedback

“Easy to work with and quick. ”

Mercantile03, United States.

Top entries from this contest

elqueabandona Argentina

0
osamasuleman Pakistan

0
tangentph Australia

0
SondySunaryo Indonesia

0
rahathossenmanik Bangladesh

0
thahamanzilg India

0
ryanweiss3 Canada

0
aman1995123 India

0
CarolinaCardoza Venezuela

1
CarolinaCardoza Venezuela

0
SunniaImran Pakistan

0

View More Entries

Public Clarification Board

osamasuleman
- 5 years ago
Done
- 5 years ago
SondySunaryo
- 5 years ago
Done sir, please check my entry
- 5 years ago
CarolinaCardoza
- 5 years ago
Cleaned Files completed (Just Categories description in cells) : No "0" , No #NA and Semicolon included. Entries #5 and #6
- 5 years ago
SunniaImran
- 5 years ago
Done. please check
- 5 years ago
Contest Holder
- 5 years ago
It is loaded in the description attachment
- 5 years ago
mohnot13
- 5 years ago
Hey, please upload the excel files
- 5 years ago
1. Contest Holder
  - 5 years ago
  Done
  - 5 years ago
ajit24
- 5 years ago
where is the excell file
- 5 years ago
1. Contest Holder
  - 5 years ago
  Done
  - 5 years ago