Excel File conversion data from BigCommerce format to Springboard Retail format
- Status: Closed
- Hadiah: $100
- Penyertaan diterima: 11
- Pemenang: elqueabandona
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.
Maklum balas Majikan
“Easy to work with and quick. ”
Mercantile03, United States.