How do I download my inventory (and orders) showing the Brickstore Item ID in a STAND-ALONE field?

Calibrick

Hi friends! This may be a silly newbie question (I apologize, if so), but I'm a bit challenged trying to figure out how to DOWNLOAD my inventory (and later orders) in such a way that displays the Brickstore Item ID in a stand-alone field.

I know uploads work, else my inventory wouldn't have uploaded. I'm thinking ahead toward my tax payments... I have setup an offline spreadsheet that shows My Cost for every item in my inventory (and later to paste in orders with a macro for when I was going to use Bricklink, which I've since decided to not sell on) using a lookup table and fields in Excel based on the Brickstore Item ID so I can easily show MyCost for every item purchased, since I have to pay state taxes based on the differences between that and the sell cost by item.

The only workaround I can think of is uploading all of My Costs to Brickowl and hope that BO can maintain My Cost down to all decimal points I have it to (it's errr up to 19 decimal points for some individual parts, sigh), and then hope that BO order reports will be exportable or copyable to track this, but I simply don't know that yet since I haven't opened my store yet.

Thoughts or ideas anyone? Thanks in advance and again, sorry if this is a silly newb question!

R,
Sandy (Calibrick)

BrickGenie

I'm not sure as to how many decimal points BrickOwl saves for the mycost field (probably 2 or 3) but seeing as your sale price is going to be 3 decimal points max it's pretty safe to round your mycost to 3 decimals as well. The tax man won't care about anything more than 2 decimals so those fractions of a cent won't matter.

Calibrick

Thanks BrickGenie... I was just hoping to avoid that was all. I'm errrr really detail-oriented. ;-) (the kind of person folks love to have around or hate to have around depending on the situation, lol).