Menu
I've not designed a point of sale before and frankly, don't have much knowledge of what attributes are needed. I found a design and realized that it still won't store everything I need. I'm still missing some attributes.
Some of the issues that I see with this digram:
I think I can add a total column to the invoice table but I'm wondering why it wasn't there to begin with. So where should these attributes go?
Can someone please tell me what I am missing here to handle the bulleted items above?
I have an an image that I want to show but unfortunately, I need 10 rep points to do this which I don't have. Maybe after a small discussion I will have earned these points to upload the image.
871
POS design is 'Point of Sale design'. It refers to the practice of designing promotional items that sit near till points in retail environments. Promotional materials include items like leaflet holders, countertop mats, stickers and 'wobblers', which attach to the till itself and draw attention to promotional messages.
These features include the ability for customers to use two types of payment, for example, or to allow for returns, special pricing (for sales or special customers), gift cards, and surge pricing.
POSM (also called POPM or POP) stands for “Point of Sale Materials”. These are advertising materials that are used to communicate product information to the consumers at the point of sale.
If you don't want to or cannot create new tables and logic in the design you found:
•I need to allow for product returns.
Product returns could be treated as a purchase using the customer as a supplier and matching the price and shipping or duplicate the sales related table and call it returns. Adjust the accounting system to apply the total from the returns as a credit instead of a debit.
•I need to allow no charge items. (Free)
•There should be an allowable discount for each product and also an additional discount that can be applied at check out.
Does your template system support cupons? If not add an item in inventory which does not have a price and alow the price to be adjusted during the sales approval process. Do not change the price for an item but include a discount of 100%
•The pos_invoice table doesn't have a total attribute.
Totals are calculated and do not need to be stored in the DB but sometimes are for speed. (reading only sales header table insted of calculating from sales detail records.
•How to handle voided transactions...
Most POS system employe some type of authorization prior to shipping. Does you template POS have an authorization system? If so add a decline reason of "Void".
OR
Contract with one of the web hosting sites and use their shopping cart feature which does everything you want and more.
85
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
