simonmiller
New Member
- Joined
- Dec 31, 2010
- Messages
- 19
Guys and Girls
Im going to try and explain this as best as I possibly can, but it is driving me crazy.
I have a price list from my supplier with the new prices.
I then have my Accounting software where I need to update the cost and retail prices. The problem I have is the Accounting software has allocated it`s own Unique ID for each item. So in order for me to bulk import this I need to keep this unique ID with the Actual Product ID together otherwise it will duplicate the product.
Here is a example
Sheet to be updated (Cost and Retail only) from PRICE LIST SHEET
<tbody>
</tbody>
PRICE LIST SHEET New Price list to copy from
<tbody>
</tbody>
Please let me know if this is not clear.
Thank you very much
Im going to try and explain this as best as I possibly can, but it is driving me crazy.
I have a price list from my supplier with the new prices.
I then have my Accounting software where I need to update the cost and retail prices. The problem I have is the Accounting software has allocated it`s own Unique ID for each item. So in order for me to bulk import this I need to keep this unique ID with the Actual Product ID together otherwise it will duplicate the product.
Here is a example
Sheet to be updated (Cost and Retail only) from PRICE LIST SHEET
Uneque ID | SKU | Product | Cost | Retail |
as123dsa-123 | 040-5001 | Fitting 1 | 5.00 | 10.00 |
2weer432-4523 | 040-5001 | Fitting 2 | 6.00 | 10.00 |
<tbody>
</tbody>
PRICE LIST SHEET New Price list to copy from
SKU | Product | Cost | Retail |
040-5000 | Fitting 1 | 7.00 | 15.00 |
040-5001 | Fitting 2 | 9.00 | 20.00 |
<tbody>
</tbody>
Please let me know if this is not clear.
Thank you very much
Last edited: