Home› General

Bulk update cost of inventory

BricksNorwayBricksNorway
edited January 2015 in General Vote Up0Vote Down
Hi. I am new to BO, so appologies if my quedtion is daft:
I would like to bulk add a cost per gram or kilogram lego i sell. Is that possible? Adding "my cost" per item seems a bit time consuming :)

Comments

  • 6 Comments sorted by Votes Date Added
  • LawrenceLawrence
    Vote Up0Vote Down
    That's not possible without using the API I'm afraid
  • BricksNorwayBricksNorway
    Vote Up0Vote Down
    Ok thank you very much :)
  • StragusStragus
    Vote Up0Vote Down
    You want to set a "My cost" that is proportional to the weight of the parts? That's rather weird...

    There might be some kind of relation between part weight and value, but there's a lot of variance.
  • BricksNorwayBricksNorway
    Vote Up0Vote Down
    Maybe weird, but from time to time I buy Lego by the kilo locally and put it up for sale, so I actually have 2 "weird" ways of calculating:

    1. Average profit per kilogram (yes, indeed the lots may vary here)
    2. Profit per lot (was it a good buy or not)

    For the second one, profit per lot, I would have to assign a "lot number" to all bricks from that lot, to be able to track it later. That could possible be done by first adding the whole lot to my inventory, then downloading the file to excel, add a lotnumber in the "personal info " field or something and then uploading again?
  • figbitsfigbits
    Vote Up0Vote Down
    What's awkward is how you are allocating the cost. Imagine two bulk lots that you bought. One is a few Bionicle parts, and a 2x4 brick, and the other is some minifig parts and a 2x4 brick.

    If you figure out your cost per part based on the weight of the parts, you will find that you paid A LOT more for the 2x4 brick that was with the minifigs than you did for the one with the Bionicle. If you sell both bricks, your profit margins will be wildly different for each one -- you may even show that you lost money on the one from the minifig lot!

    It does make sense to try to calculate your profit per bulk lot. But you likely want to allocate your cost differently. The simplest way is probably based on what you are going to list it all for.

    So, if you buy a bulk lot for $10, and the sum of the prices that you list everything for in your store is $50, then each piece in the lot should be set to have a MyCost value of 1/5 of your listed price.

    Or, if there are some lots that you aren't sure what you will price them at, but you want to get all your costs allocated right away, you can use average sale price instead of your listed price.


    --
    Marc.
Sign In or Register to comment.