search-icon

Bulk price update without need to export/import full product list

started a topic about 2 years ago

It would be a great help if there was a way to do bulk price updates without having to export/import the full product list. It might take a few days to make price updates on a xlsx sheet before it's ready to import. In that time, many other product attributes could've been changed by the team, e.g. product description, bin locations, etc... So I'm suggesting a simple template with columns: SKU, PRICE TIER 1, PRICE TIER 2......, PRICE TIER 10. Like/comment/vote if you agree

14 people like this idea
  • I strongly agree with Daniel that we need a simpler product list to work on. For now we must keep all columns headings and they must be in the same order. It would be a great help if we can remove the columns that we do not need to modify and also be able to rearrange column orders.

    4 people like this
  • Agree. Ideally you would select / filter to the products you want to update and then it would just export the displayed / selected items, not the complete Product list.


    3 people like this
  • How about an import like WooCommerce? You can match any fields you like and only the ones you want updated during the import process.


    1 person likes this
  • Yes please, this would save a lot of faff for us!


    2 people like this
  • Much needed feature. 


    With the sheer number of products in our inventory, the inability to create/update products while the price list is being reviewed and updated is a substantial problem.


    Our prices update every two months, having a feature to only update price fields and not everything else is a requirement.

  • For those of you freezing your system of any changes during price evaluation, the easier thing to do is just format everything in your inventory export down to what you need to evaluate price changes (aka deleting columns you don't care about) and then just run a simple difference script against a fresh inventory export based on SKU and appropriate columns and then pull anything that's different into the fresh DEAR inventory export before uploading it.
    Functions like

    =INDEX(Inventory!<full index range of inventory sheet>,MATCH(A2,Inventory!$A:$A,0),MATCH(<index of column header you care about>,Inventory!$A:$CD,0))

    work wonders in Excel and Google sheets.

Login or Signup to post a comment

14 people like this idea
Log in or Sign up to post a comment