Excel File conversion data from BigCommerce format to Springboard Retail format

  • 状态: Closed
  • 奖金: $100
  • 参赛作品已收到: 11
  • 获胜者: 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.

您还可能感兴趣的技能

Winner
加精竞赛
发布一个类似的竞赛

雇主反馈

“Easy to work with and quick. ”

个人主页照片 Mercantile03, United States.

此竞赛的顶尖作品

查看更多参赛作品

公共说明面板

  • osamasuleman
    osamasuleman
    • 5 年 之前

    Done

    • 5 年 之前
  • SondySunaryo
    SondySunaryo
    • 5 年 之前

    Done sir, please check my entry

    • 5 年 之前
  • CarolinaCardoza
    CarolinaCardoza
    • 5 年 之前

    Cleaned Files completed (Just Categories description in cells) : No "0" , No #NA and Semicolon included. Entries #5 and #6

    • 5 年 之前
  • SunniaImran
    SunniaImran
    • 5 年 之前

    Done. please check

    • 5 年 之前
  • Mercantile03
    竞赛主办者
    • 5 年 之前

    It is loaded in the description attachment

    • 5 年 之前
  • mohnot13
    mohnot13
    • 5 年 之前

    Hey, please upload the excel files

    • 5 年 之前
    1. Mercantile03
      竞赛主办者
      • 5 年 之前

      Done

      • 5 年 之前
  • ajit24
    ajit24
    • 5 年 之前

    where is the excell file

    • 5 年 之前
    1. Mercantile03
      竞赛主办者
      • 5 年 之前

      Done

      • 5 年 之前

显示更多评论

如何以竞赛开始

  • 发布您的竞赛

    发起您的竞赛 快速简单

  • 获取众多参赛作品

    获取大量参赛作品 来自世界各地

  • 悬赏最佳参赛作品

    悬赏最佳参赛作品 下载文件-简单！

立即发布竞赛 或者立即加入我们！