Skip to Content

How to Enter New Prices According to the Manufacturer List

How to enter new prices according to the manufacturer list

How can I quickly transfer new prices from manufacturer lists to the shop?

In product management, you often receive manufacturer lists with new product prices for some products, so that not all prices need to be adjusted. You now want to find out which products are included in the list and update them with the new prices. For this, you will match the manufacturer supplier list with your own shop data in cobby using the XLOOKUP formula.

In the demo, we have put together the step-by-step guide for you to read.

Demo


Step-by-step guide

1. Open manufacturer list in Excel
Open the manufacturer list with the new prices in Excel. In our case, we have the SKUs, the cost price, the minimum margin, and the new prices available as values.

2. Load products
Download your products from the shop in Excel now by clicking on "cobby" in the tab and then on the "Load Products" button. Don't worry, your list with the prices won't disappear, as it will remain in its own worksheet within the workbook. Advantage: You have the manufacturer list and your cobby data in one workbook, so you can quickly cross-check!

All products from your online shop will then be displayed. You can also load your product data via the filter or a preset if needed.

3. Adjust view
For better clarity, you can first create your own product view for editing (e.g., hiding unnecessary columns and moving needed columns).
[Learn more about how to create your own view here.]

4. Create auxiliary column
Create an auxiliary column next to the attribute "Price" to have a sort of note field where the new prices can be entered later.
[Learn more about how to create auxiliary columns here.]

5. Matching of SKU and price
Now we want to start the matching of the SKUs with the prices to find the products that should receive a new price. 

  • Type the formula =xlookup in the line for "New Price". 
  • By double-clicking on the xlookup, you select the formula. 
  • Then click on fx in the top left to open the function field.

6. Enter formula parameters: search criterion
In the function field, you now see the 3 parameters that need to be filled in for the XLOOKUP formula: search value, search matrix, and return matrix. Select the SKU as the search criterion by clicking on the corresponding row in the "All Products" spreadsheet.

7. Enter formula parameters: search matrix
Click now in the parameter field for the search matrix to select the corresponding column. Go to your worksheet with the manufacturer prices from the beginning and select column A as the search matrix, which contains the SKUs.

8. Enter formula parameters: return matrix
Select column D in the same table as the return matrix. These are the new prices that should be returned in your product view. Finally, click OK, as all relevant parameters are now filled in.

9. Apply formula to all other SKUs
After you click OK in the function window, the function will be applied and will now show you the new price for the SKU in the AllProducts worksheet. Great!To apply the formula to all SKUs, click on the small plus and drag it down.Now the new prices for the remaining SKUs will also be displayed accordingly.

10. Adjust product view: Hide #N/A values
For the SKUs that do not receive a new price, #NV is displayed, as no value could be found there. However, since we are only interested in the items with a price, we will adjust the view again.

  • Select the Excel filter in the "New Price" column.
  • Then, uncheck the box for #N/A at the bottom so that all items with no value are hidden for a clean view.
  • Confirm your setting by clicking "OK".

Now only the SKUs with the new prices are displayed.

11. Transfer prices from the auxiliary column to the "correct" Price column
There are two ways to transfer the new prices:

  • (1) manually
  • (2) semi-automatically

(1) The first way would be to manually transfer the price, so just type the price into the corresponding cell in the "Price" column.

(2) The second way would be to click into the corresponding Price cell, and at the top in the formula bar, type an "=" and select the cell with the new price. In this case, it would be "=(select cell F3)"
OR
you just type it in yourself "=[@[New Price]]"
If you have transferred the price, the product status will change to yellow due to the modification.

❗ Attention when using copy & paste
The reason for manually transferring or using the formula ("=[@[New Price]]") is that when doing a complete copy & paste from the "New Price" column to the "Price" column, hidden Excel rows that should not be edited are also overwritten.

12. Save
Click now on "Save Products" to immediately apply the changes to your shop or...

✨ 13. Bonus tip: Use cobby offline
Sometimes, calculating new prices can take several days, so incomplete changes should not go online immediately. With cobby, that's no problem! You can use cobby in such a way that the new prices only go online once all changes have been made.

[Learn here more about how to use cobby offline and how to upload changes later.]

Excellent! 🎉

Now you know how to manually or semi-automatically integrate new prices from manufacturer lists into your shop.

Rating
0 0

Momentan sind keine Kommentare vorhanden.

, um als erster einen Kommentar zu hinterlassen.