Inventory Management Unit Cost

[jackieGPR]

I have switched to inventory management and I am excited that we can add a unit cost. I have downloaded the CSV file and I have added all of my unit costs to the spreadsheet. I used a macboook pro for this. I attempted to import the spreadsheet to my inventory management, however it gives me a message that reads "Updated 0 unit costs. Skipped 489 previously-assigned unit costs". Long story short, I have been unsuccessful with all attempts of updating my unit costs. I followed the instructions, am I doing somehting wrong? Does the Numbers from apple not support the file? I tried to convert it back to a csv file after updating the spreadsheet unit costs via numbers, but still no luck. 

[Tom]

Hey @jackieGPR, thanks for flagging this!

It sounds like you may be referring to the Square for Retail app. Generally speaking, you'll need to have an inventory count of at least one in order to be able to import. It may be helpful to touch base with our Support Team so that they can have a closer look at your settings.

Hope this helps get you in the right direction. Please let us know if anything else comes up.🙂

[hlowen]

Hi All, 

I have followed everything I can find here, and elsewhere. I am trying to import all of the unit costs for our inventory and it will simply not update the unit costs. It updated the actual stock, but not the unit costt. I feel like I am banging my head against the wall. I have filled out the template exactly as it was downloaded,  and when it imports it says, 0 unit costs updated.

Moreover, when I try in any way to see if the system has indeed uploaded the unit costs either via creating PO or looking at inventory reports, i'm getting no where.

Can you help me

1. how to see what unit cost a said item has?

2. Why the inventory report would say $0 when we have close to 80 items in stock, and supposedly with unit costs imported?

Thank you!

[Tom]

Hey @hlowen, thanks for reaching out and sorry to hear about the trouble with getting set up.

I will do some digging and see if I can find more information on the questions you asked. In addition, you can get in touch with someone on our Retail Support Team directly, if you wish. Appreciate your patience!

[Tom]

Hi @hlowen, I was able to take a closer look and touch base with some team members.

There may be a chance that you already have unit costs associated with your inventory. To check on this, you could export the Unit Cost Template and refer to the CSV file for any items that do not have the cost associated with them. Another way to confirm this is by selling an item and checking the Cost of Goods Sold report for any changes to the reporting for that item.

If you do have the unit costs and would like to replace them, you would need to zero out the inventory which would allow you to import the inventory with the correct unit cost. If you don't have unit costs already associated with the items, there may be something that we need to escalate for further review.

If this doesn't get you where you need to be, please give us a call and we'll be able to get this sorted out together. 🙂