Spreadsheet for Ebay / Advice

Hi Guys i will try to keep this short. I am looking for anybody that has a Spreadsheet used for selling on Ebay. I have seen some entries and i have seen some for sale but they are all in $ and i am in the UK. I know i could alter them but i feel a little uneasy buying a spreadsheet that i have to alter to fit UK fees and the cosmetic looks. Also i have found these sheets are often locked.


There must be somebody who has done one for the UK or am i in the wrong Forums???

Just looking for some help in the matter or advice cheers guys

Dale

Hi Mike

I am not going to buy one due to the reasons mentioned. But i am no Excel Guru and some of the sheets i have seen have been well designed what bit i have seen of them.

I was only looking at the paid root v my novice time creating one.

I am generally ok at basic Excel but i didn’t want to spend weeks creating one, only to find months later i had missed some critical items.
Which would mean me re building it and re populating it. I am not a lazy person but i do not believe in reinventing a basic wheel when others have a alloy wheel already running.

If it was possible for me to see a full designed one then create one i would be happy to do that.
As i know there is always plenty of help on here and other forums.

Dale

Hi thorrrr,

I have attached a very basic spreadsheet that I did for another thread (Calculating retail price.
I have made a couple of adjustments since then.
It may not be what you are looking for but it may give you a start.
In column A you could add Data Validation so you would have a drop-down list of what you sell.
Also, adding VLOOKUP in column B it would automatically show the price of the item chosen in column A.
"All" that's left for you to do is decide how much profit you want make!
If I can help any further please let me know.

Regards

peterrc

Hi thorrrr,

Apologies.
I didn't update the formulas when I added more rows.
The formula in D29 should be =AVERAGE(D6:D27), and
The formula in J29 should be =AVERAGE(J6:J27).

Regards

peterrc

Hi Peter

Cheers for your help in the matter i am leaning more towards a Access DB solution in the long run.

Cheers

Hi Mike

Need to record the following items and avoid duplication

I visit trade retailers weekly and record date , stock item price and track it over several weeks / months
I want to record stock i have purchased
I want to record stock i have Actively Listed on my Ebay , Amazon and my own Website (when i finished building it)
I have a Excel sheet i use for market research
I have a Excel sheet for stock control another for Listings on Ebay / Amazon
I have a sheet for stock dimensions weight shipping Basic , Shipping Express Shipping International.
Sale Sheet
Expenses Sheet
TAx / Vat Sheet.

Doing all this in Excel i think will look messy but you may have an opposite view .

The data expands daily

Dale

Hi Mike

Not 12 000 000 that’s for sure

I guess 50 to 500 items a month to be honest.

I want to do several things i visit a local Costco maybe 3 times a week and track prices of items to see the price trends. So i need to be able to do that

I buy stock from Costco to sell on Ebay / Amazon so i need details about the product

Product Code
Product Type
Desc
Units Bought
Basic Price
VAT
Total Price
Weight
Dimension
H
W
D

I need a Product Research sheet where i scour the Ebay / Amazon to see what these products are selling for. On here i list Prices then My suggested Price whichh includee Ebay Fees , Paypal Fees , Shipping Economy , Shipping Express and International Shipping with a Profit Costs re Supplies and Petrol

Ebay / Amazon Sheet Active Listing Sheet

Need a Sales and something that works out my values Price Paid , Business Costs, Sales , Tax VAT Profit

I have started a sheet but it not finished and needs adding to.

Dale