Topics

1

General Discussion / Formula help to separate SKU into separate fields

« on: April 04, 2019, 10:20:44 am »

Hi Scott,

I need some help with a few formulas. I am trying to extract data from the SKU column into 3 other columns:

Item Purchase Price
Inventory Source
Purchase Date

Here are 2 examples of my SKU's. As you can see the number of characters in each section varies depending on the item, so I can't use the position in the formula. (I need the item type (ie: CD, TXBK) in the beginning of the SKU for my repricing templates).

CD-2.00-BKCAFE-01.05.2019-01
TXTBK-13.00-STVIN-01.05.2019-101

On page 1 of this original topic I was using this formula to pull the Item Purchase Price from the SKU (see below),

2.00-BKCAFE-01.05.2017
=VALUE(LEFT(G3,FIND("-",G3)-1))

but now I need to add the item type to the beginning of the sku and also pull out Inventory Source and Purchase Date. Spent the better part of last night and this morning googling and testing with no luck.

Can you help? Thanks!
Sue

2

Feature Requests / eBay Monthly Store Fee

« on: July 13, 2017, 03:46:51 pm »

I'm thinking that the software doesn't capture the monthly store fee if you have an eBay store (correct me if I'm wrong). If not, a feature in the expenses area could be to have a column for recurring expenses, with maybe a dropdown to add it automatically monthly/quarterly, etc. In that section we could maybe add our own custom recurring expenses (ie rent, subscriptions, etc.) and we wouldn't have to add them manually every month.

3

General Discussion / Cost of Goods

« on: July 11, 2017, 12:00:44 pm »

Hi everyone!

Just downloaded the spreadsheet and I really like it so far. The one thing I would like is to be able to enter my Cost of Goods before the item sells. Almost all of my products are one-offs, purchased from thrift stores, online, etc. By entering the product cost right after listing I can file away my receipts as many items take months to sell and I would never remember what I paid at the time.

Is there a way to add the Item Purchase Price, and right next to that the supplier and purchase date, which would then also be carried over to the Sold Items page when the item sells? That way you would know your ending inventory value for year end tax purposes and also have good documentation to prove your COGS if need be.

Thanks!

Sue