peskywinnets
Registered User.
- Local time
- Today, 14:57
- Joined
- Feb 4, 2014
- Messages
- 582
I'm a one man business (still early days & with a major eye on cost...but also efficiency)...I have a sales database full of the usual stuff....customer name, billing address, shipping address, email address, Order Number, SKUs ordered, Quantity ordered, price paid etc.
I add to this main database daily by way of a text file import....essentially all new sales since the last import. What I need (because, I reckon at the moment it's beyond my ability...or perhaps more to the point, likely to be a time sump at a time when I should be focusing on my business ...not coding in Access!) is for an Access macro/VBA code to
1. Create a VAT invoice for all newly imported orders
2. Email the invoice out
3. Self update the Access database to mark the order as 'invoice emailed'.
I'll probably need step 1 & step 2 to be broken out (as opposed to chained), this is so I can check a few 'quirky' orders before the email is actually sent. However step 2 step 3 can be chained.
Basic Sample of my database...
Obviously there are a lot more fields, but I post the sample above to illustrate a couple of points....1. when a customer buys more than one product (item), there will be extra row entries (one row entry per 'different' product purchased)...each with the same common order number... 2.unfortunately the shipping the customer paid will be applied to each row (therefore in the above example, Brian Smith actually only paid £2.99 shipping, even though it looks like he paid two lots of £2.99 shipping...perhaps that quirk could be part of this job/task - remove any duplicate postages for multi product orders, leaving only the last row with the one associated postage paid?!)
So for someone that's pretty clued up on Access, how long would it take them to put together something that meets my requirements? (& how much should I expect to pay...if it's a lot of work & likely to be costly, then I'm going to have to just slog my way through it slowly, learning the pieces of the puzzle bit by bit!)
I add to this main database daily by way of a text file import....essentially all new sales since the last import. What I need (because, I reckon at the moment it's beyond my ability...or perhaps more to the point, likely to be a time sump at a time when I should be focusing on my business ...not coding in Access!) is for an Access macro/VBA code to
1. Create a VAT invoice for all newly imported orders
2. Email the invoice out
3. Self update the Access database to mark the order as 'invoice emailed'.
I'll probably need step 1 & step 2 to be broken out (as opposed to chained), this is so I can check a few 'quirky' orders before the email is actually sent. However step 2 step 3 can be chained.
Basic Sample of my database...
Code:
Order No. Item Qty Price Shipping Customer
1 widget A 1 £9.99 £2.99 Norma Stits
1 widget B 3 £19.99 £2.99 Norma Stits
2 widget C 1 £8.99 £8.99 Tom Cockles
3 widget A 1 £9.99 £2.99 Drew Peacock
4 widget E 1 £9.99 £3.99 Mary Hinge
4 widget F 1 £9.99 £3.99 Mary Hinge
Obviously there are a lot more fields, but I post the sample above to illustrate a couple of points....1. when a customer buys more than one product (item), there will be extra row entries (one row entry per 'different' product purchased)...each with the same common order number... 2.unfortunately the shipping the customer paid will be applied to each row (therefore in the above example, Brian Smith actually only paid £2.99 shipping, even though it looks like he paid two lots of £2.99 shipping...perhaps that quirk could be part of this job/task - remove any duplicate postages for multi product orders, leaving only the last row with the one associated postage paid?!)
So for someone that's pretty clued up on Access, how long would it take them to put together something that meets my requirements? (& how much should I expect to pay...if it's a lot of work & likely to be costly, then I'm going to have to just slog my way through it slowly, learning the pieces of the puzzle bit by bit!)
Last edited: