- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Order Tracking Site or Program
Posted on 7/5/16 at 8:39 pm
Posted on 7/5/16 at 8:39 pm
So my wife is literally keeping track of the orders for her small business on sticky notes and about 3 different notepads and it drives me nuts. I'm looking around for a solution for her to keep track of everything using either a database or an online option. The sample Access databases will "work" but there are some things that could be added that would really help her out. I can create a database to do what is needed but that's a lot of time I really don't have right now.
After a cursory search online, I haven't found anything that fits the bill so I wanted to see if anyone knows of an online order tracking system that can be accessed from a mobile device. The ability to upload files and pictures and attach them to an order would be a plus. Free is always good, too.
After a cursory search online, I haven't found anything that fits the bill so I wanted to see if anyone knows of an online order tracking system that can be accessed from a mobile device. The ability to upload files and pictures and attach them to an order would be a plus. Free is always good, too.
Posted on 7/5/16 at 9:25 pm to The Next
Why not a simple excel spreadsheet?
Posted on 7/6/16 at 1:31 am to The Next
NEVER ENTER A TRACKING NUMBER AGAIN
A shopper's best friend for keeping track of everything you buy online
Track Packages
Slice automatically picks up tracking numbers in your email whenever you buy something.
Get Money Back
Did the price drop after you bought it? We'll let you know and help you get a refund.
Stay Safe
Get alerted when anything you've bought is recalled by the CPSC. Keep your family safe
Access Receipts
Easily find a receipt for a return or work-related expense. No more digging through your inbox.
A shopper's best friend for keeping track of everything you buy online
Track Packages
Slice automatically picks up tracking numbers in your email whenever you buy something.
Get Money Back
Did the price drop after you bought it? We'll let you know and help you get a refund.
Stay Safe
Get alerted when anything you've bought is recalled by the CPSC. Keep your family safe
Access Receipts
Easily find a receipt for a return or work-related expense. No more digging through your inbox.
Posted on 7/6/16 at 1:39 am to The Next
I use handshake.com as a user friendly App. I assume you use an IOS platform, since you don't use Excel for this simple procedure. I have a Linux based patch that I built to convert this App to a Windows based platform that I back up with a simple Access database. I utilize this for my own records keeping.
But really, you should use Excel for this simplistic approach in records keeping.
But really, you should use Excel for this simplistic approach in records keeping.
This post was edited on 7/6/16 at 4:13 am
Posted on 7/6/16 at 8:02 am to Breauxsif
Google Sheets can be accessed via mobile device
Posted on 7/6/16 at 8:13 am to The Next
I've used the Parcels app on Android. It updates tracking status either manually or automatically.
Posted on 7/6/16 at 8:46 am to LSURoss
I could do excel but it doesn't give the functionality she would really need. She also has a desktop folder that is completely unorganized so I'm trying to give her the ability to upload files and have it automatically be organized and easily accessible through the program. I've set up access databases and I know I can do what I need with it. I just don't have the web programming knowledge (yet, at least) to allow her to enter the orders from her phone.
Handshake looks promising but I'm really looking to keep her costs down as much as we can.
Handshake looks promising but I'm really looking to keep her costs down as much as we can.
Posted on 7/6/16 at 11:47 am to The Next
So I always try to design a system that can allow for me to track shipments with relative ease when using Access.
Here is my basic criteria/constraints before converting to SQL:
1. Each shipment must have at least one tracking number (depending on the carrier, each package will have its own tracking number so a shipment very well could have multiple tracking numbers associated).
2. For truck carriers, they use one tracking number for a shipment. A shipment can consist of multiple orders (this is part of my problem).
3. Once used, tracking numbers cannot be repeated
4. Once an order is shipped, it cannot be shipped again
Here is my basic criteria/constraints before converting to SQL:
1. Each shipment must have at least one tracking number (depending on the carrier, each package will have its own tracking number so a shipment very well could have multiple tracking numbers associated).
2. For truck carriers, they use one tracking number for a shipment. A shipment can consist of multiple orders (this is part of my problem).
3. Once used, tracking numbers cannot be repeated
4. Once an order is shipped, it cannot be shipped again
This post was edited on 7/6/16 at 12:00 pm
Posted on 7/6/16 at 11:56 am to The Next
When you're implementing query wizard be sure to include the following:
Orders
OrderNumber (PK)
CustomerID
IsShipped (boolean/bit)
Shipments
ShipmentID (PK)
ShipDate (date)
CarrierID (FK Carriers table)
Tracking
ShipmentID (FK Shipments table)
OrderNumber (FK Orders table)
TrackingNumber (PK)
(In the Tracking table, ShipmentID, OrderNumber, and TrackingNumber would make up the primary key/composite key).
Hopefully this helps in clarifying the basics using Access and RDBMS, whereas it can get way more complicated. It helps to practice it for organizational purposes.
Orders
OrderNumber (PK)
CustomerID
IsShipped (boolean/bit)
Shipments
ShipmentID (PK)
ShipDate (date)
CarrierID (FK Carriers table)
Tracking
ShipmentID (FK Shipments table)
OrderNumber (FK Orders table)
TrackingNumber (PK)
(In the Tracking table, ShipmentID, OrderNumber, and TrackingNumber would make up the primary key/composite key).
Hopefully this helps in clarifying the basics using Access and RDBMS, whereas it can get way more complicated. It helps to practice it for organizational purposes.
Posted on 7/6/16 at 12:37 pm to Breauxsif
I guess my OP was a little confusing. This wouldn't be to track orders that she places to have items shipped to her. This would be for people placing orders with her business so she can keep everything organized so as to not have to go to 3 separate notebooks to find out what her customers want. She creates embroidery files for each customer so it would be nice to "attach" that file to a particular order under a customer account.
Although, now that I think about it, implementing a PO system and tracking shipments might not be a bad idea. Great. More work.
Although, now that I think about it, implementing a PO system and tracking shipments might not be a bad idea. Great. More work.
Posted on 7/6/16 at 1:09 pm to The Next
That's why I mentioned handshake.com initially. It was a little unclear at first. However, check out the site nevertheless.
Posted on 7/6/16 at 1:14 pm to The Next
Check out smartsheet.com as well. It's an online project management SaaS platform that's user friendly. You can import existing excel files to coordinate orders placed on the consumer end and easier to use instead of Access. It has a free trial to see if it'll work out for your needs.
Popular
Back to top
Follow TigerDroppings for LSU Football News