Normal Topic Sesame for Point-of-Sale...Is it possible? (Read 957 times)
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Sesame for Point-of-Sale...Is it possible?
Feb 21st, 2004 at 8:23pm
Print Post Print Post  
I bought Sesame thinking it could be used as a point of sale system, as well as a "back-office" inventory/database manager.

I'm having a hard time deciding what forms would work off of what databases, etc.

If anyone has any experience, and would like to share it, I would LOVE to hear.

Example, can we scan a barcoded item to retrieve and update the info from the "inventory" database, AND enter a customer phone number to retrieve and update the customers info from a different database....all while working on an Invoice Form?  Ive tried using subforms but cant seem to Search AND Update the two databases at one time. Maybe Macros are needed?

Thanks for all your insight and assistance.

Steve A.
Oriental Rug Gallery of Texas
San Antonio
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Sesame for Point-of-Sale...Is it possible?
Reply #1 - Feb 22nd, 2004 at 2:55pm
Print Post Print Post  
If you have a keyboard wedge (which you probably do), then the computer sees no difference between characters entered by scanning the barcode and characters entered by typing. Scanning data and performing an XLookup OnElementChange or OnElementExit should not be a problem.

You should be able to use the SelectTreeItem commands or macros to retrieve a customer record, but exactly how it works depends on the specifics of what you are trying to do.

I don't see subforms being an appropriate solution for either of the tasks you describe, although subforms would be appropriate for multiple line items on an Invoice.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Sesame for Point-of-Sale...Is it possible?
Reply #2 - Feb 22nd, 2004 at 4:34pm
Print Post Print Post  
Hammer,

Thanks for your response.

So your suggesting we should search/update a customer record first, and use a subform for the individual line items from our inventory database? It makes sense.

I guess I'm still unclear as to how many databases we should have. I assume:

database 1: customer info (w/ subform to inventory purchase history)

database 2: Inventory info (w/ subform to customer info if items is sold)

database 3: invoices (w/ subforms to customer info, inventory being purchased).

Or am I being redundant? Should I just put this all into one massive database?

Thanks again for all your help!
Steve
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Sesame for Point-of-Sale...Is it possible?
Reply #3 - Feb 22nd, 2004 at 4:49pm
Print Post Print Post  
Steve,

Are your items for sale unique? Is each rug an individually identifiable item, or do you carry 50 of the exact same rug?

Does each invoice represent the sale of a single item, or can you sell 5 rugs to the same person on the same invoice?
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Sesame for Point-of-Sale...Is it possible?
Reply #4 - Feb 22nd, 2004 at 4:58pm
Print Post Print Post  
Hammer,

Currently we have mostly unique items with individual stock numbers, but some are "sku" items so 1 stock number may represent 30 identical rugs. We are considering doing away with sku numbers and giving each items its own stock number, making scanning and inventory control much more precise.

We quite often sell several rugs to one customer. If the customer comes back to buy more, we would like to pull up their previous sales history and then scan in their new purchases rather than type in their customer info (name, address, phone, etc) each time they buy something.

Again, I appreciate your help in starting me off in the right direction.

Steve
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Sesame for Point-of-Sale...Is it possible?
Reply #5 - Feb 23rd, 2004 at 1:36pm
Print Post Print Post  
Hi Steve,

I can't really perform on-the-fly application design with such a limited knowledge of your needs, but I'd head in a direction like this:

PointOfSale Application
--- Customers database and Form, where each record represents one Customer
--- Inventory database and Form, where each record represents one unique item for sale
--- Invoices database and Form
------ Line Items database and Form (used as naturally linked subform on Invoices Form) 

Invoices should include the CustomerID, which can use XLookups to fill in address info. LineItems should include the InventoryItemID (from your barcode), which can use XLookups to fill price, description, etc.

To get a Purchase History for a Customer, search the Invoices database or run a Report. To find who bought a particular item, again, search the Invoices database for that item number. By searching in a subform, you will find any parent (invoice) record under which that item appears.

I hope this helps to get you started.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Sesame for Point-of-Sale...Is it possible?
Reply #6 - Feb 23rd, 2004 at 3:27pm
Print Post Print Post  
Thanks Hammer! I'll read up on Xlookups.

Your help is greatly appreciated!

Steve
  
Back to top
IP Logged