Stock Control

[teenymunchkins]

How do you guys who have your own stock manage your stock control?

Up until now I have not had any proper form of control but as I move onto next steps with my business I need to do it much more efficiently.

I need to find a way of getting stuff booked in as it arrives, booked out when it sells and keep an up to date running tally of how much of a product I have in?

Can anybody recommend any good software that doesn't cost the earth that can cross-reference?

Thanks
Alison

[DeputyDog]

http://www.imonggo.com/

Cheap at half the price

Its also FREE if you only have a small number of products

 

[teenymunchkins]

That looks great, thanks for that    Seems to be just what I need.

Will let you know how I get on

[gordym75]

Just a thought but would anyone use an Access database to control their stock? The reason I ask is I'm pretty handy with Access and I personally would use it for that, although it would be a database I had created specifically for my purposes.

[goldenaxe]

Good old Excel does the trick

[Gothic Dropshipping]

I need to find a way of getting stuff booked in as it arrives, booked out when it sells and keep an up to date running tally of how much of a product I have in?

Perhaps I'm missing something here, but sure your shopping cart does this?  if you add stock as it comes in, the cart deducts stock as you sell it, so the stock quantities in your shopping cart should be 100% accurate, and you can easily print of stock lists etc. using easypopulate or play with them in excel

[teenymunchkins]

I need to find a way of getting stuff booked in as it arrives, booked out when it sells and keep an up to date running tally of how much of a product I have in?

Perhaps I'm missing something here, but sure your shopping cart does this?  if you add stock as it comes in, the cart deducts stock as you sell it, so the stock quantities in your shopping cart should be 100% accurate, and you can easily print of stock lists etc. using easypopulate or play with them in excel

You are right ... I can do it that way.  I just fancied a nice little package that I can keep inventory and accounts all in one place 

[Gothic Dropshipping]

I do hear what you're saying as I did consider it at the start, but I'm lazy and thought inputting my stock into the cart was enough without having to do it somewhere else also 

I think setter sells a mod that lets you enter your cost price into Zen also although I've never got round to buying it but it would be handy

[gordym75]

If you download the ep file in zencart it can easily be imported into other database applications too. That would save inputting it twice.

[Gothic Dropshipping]

indeed it would 

[DeputyDog]

What about if the product cost price changes  ?

Say you buy 10 items @ £5.00 this week & next week the price is £5.75

The http://www.imonggo.com/ software works out the average cost price and on average weekly/monthly sales and much more .

 

[DGTG Wholesale]

I would suggest plain and simple excel, set one row up for item number, colour, size, qty and location, it is simple and straight forward and can easily be attached as spreadsheet in an email or uploaded to any site for easy download by your customers.

[SIMPLYGORGEOUS]

I use a similar thing in MAC called Numbers, it allows me a small image as well which i find really helpful.

Plus i can keep track on what ive orded in as well