homepage Welcome to WebmasterWorld Guest from 54.227.34.0
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / WebmasterWorld / Ecommerce
Forum Library, Charter, Moderators: buckworks

Ecommerce Forum

    
Software choice for startup website dealing in wholesale orders
my business system sucks and i need a semi-automated solution
happy martin

10+ Year Member



 
Msg#: 3236862 posted 7:46 am on Jan 30, 2007 (gmt 0)

Hi everybody,

I've begun a business exporting metal artwork from a company in Thailand to customers overseas. Currently we have one client who's given us a lot of business. Currently though the workload for me is taking up a lot of my time as both myself and my customer are just beginning and we are trying to create a business system as we go along.

I have already presented the customer with a large speadsheet of products, descriptions and prices. He often replies back by email to me with the quantity and product codes he'd like to order. I am then copying the entire catalogue to a new spreadsheet and deleting all but the persons order. I'm next having to manually create an invoice for them.

Now I have the order from the customer I have to duplicate the excel spreadsheet to forward on to the company i work with in Thailand. I need to replace the $US prices I've quoted my customer with the Thai baht prices I've been quoted myself. When I do this I email it to the artwork company.

My 'system' has lots of room for errors as I'm effectively having to create new excel spreadsheets each time and I'm dealing with both thai baht with the company and $US with my customer. Half of my time seems to be spent checking my spreadsheets and correcting errors.

Do any of you have any suggestions for software which can streamline my work process? I'm sure something good already exists but I'm struggling to find anything.

Thanks in Advance

Martin

 

rharri

10+ Year Member



 
Msg#: 3236862 posted 4:22 pm on Jan 30, 2007 (gmt 0)

Martin,
I don't know of a specific, existing package but a web-based database solution seems what you are looking for. Basically, a "products" table, tied to US and Thai prices. An editing component to add product and adjust prices and a view component to show all products and selected products +/- prices.

Bob

ytswy

10+ Year Member



 
Msg#: 3236862 posted 6:01 pm on Jan 30, 2007 (gmt 0)

I may be misunderstanding your requirements, but it sounds like you are just after a basic sales system: you need to be able to select your customer, enter the product codes + quantities that he has ordered, and then have it output an invoice (with sell prices) and a purchase order (with buy prices).

If that is all you are doing - you're not after ecommerce functionality or anything - then you can do it easily in any basic database package, MS Access for example. If you search around, you'll find that about half the tutorials ever written use a sales system like this as their example.

Of course you'll outgrow a system like this, and maybe you should try and do something better to start with, but if you are spending all your time messing around copy/pasting in excel files almost anything would be an improvment.

skywhy2387

5+ Year Member



 
Msg#: 3236862 posted 5:18 pm on Feb 1, 2007 (gmt 0)

I think quickbooks is the way to go. They have versions for wholesalers I think its the premier. Anyway good luck.

happy martin

10+ Year Member



 
Msg#: 3236862 posted 5:30 pm on Feb 1, 2007 (gmt 0)

Thanks for all your help so far.

I use a mac computer so began to enquire about having somebody build me a basic database in Filemaker Pro to deal with my needs and I have been quoted $3000+ for the work!

I'll take a look at quickbooks now as it seems - so far - that although I'm certain my business is pretty standard, there's no simple program that will cater to my needs.

As a last resort it looks like it might be most practical to pay a PHP programmer to build something online for me.

Best wishes,

Martin

ytswy

10+ Year Member



 
Msg#: 3236862 posted 11:51 am on Feb 2, 2007 (gmt 0)

I've got a lot of experience using Filemaker for this kind of system. My advice, if you're paying someone for the work is, don't do it! Even if you can get a reasonable quote.

Filemaker is good because it's easy to do for yourself, but it's a horrible mess compared to a proper database. If you're paying someone to do the work then get one that can grow with you, rather than one that will turn into the 6 year old kludge I'm using.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Ecommerce
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved