Address Invoicing Issue

This project is to make various updates to an operational e-commerce website. These updates will need to be implemented over the weekend, when the website usage is slow, generally after 9PM EST Friday to 9AM EST Sunday. The site is an operational e-commerce site, and I don't want any downtime. I believe all pages are in php5 and database is mysql. The site uses custom coding, no [url removed, login to view] server uses Cpanel and Web Host Manager (WHM) with CentOS, and system admin is pretty helpful.

Website is more complex than it may seem by the description above. The next comment is from a coder who reviewed the code " Code is in simple PHP, but it is based on URL-Rewriting. You may have to workout for the page before making the requirements"

Website is set up with a test area, but existing operational DB and files will need to be exported and imported into the test area.

We operate a business where all of our orders are managed via a website/database. We have around 2200 agents/customers who work for close to 600 different agencies. The agents/customers log in and place their orders. The vast majority immediately pay via their personal credit card. About 25-35% of the orders are paid via invoice that is sent to the agency. An agency invoice lists all of the different customers who work for that agency, and lists all of the orders placed in the previous month.

We have a working invoicing system, but we have one issue. If Customer A switches from Agency X to Agency Z, all of the previous orders for Customer A are moved to Agency Z's account. We need this to stop happening. If an order is placed with a specific agency by a specific customer, that order information needs to stay with that agency, even if the customer switches to a different agency.

Also, we have not gone live with the invoicing system due to this issue, but the invoicing data has been populated with existing orders. Once the issue above is fixed, we will need all of the past invoicing data cleared from the new system, so we can have a clean start as we implement this feature to our customers. FYI, we are currently using a totally different system to do the actual invoicing.

Below is some info on the Invoicing System that is being developed, to give you an idea of what is involved:

2. Invoicing system should send an e-mail on the 1st of the month to all "Invoice" customers.

2a. E-mail invoices should contain all the information on existing invoices. This information should be easily modifiable, particularly mailing address and contact info.

2b. Invoices will need to be individually numbered, perhaps incorporating month/year the invoice was generated.

2c. E-mails invoice system will need to incorporate sending e-mails to the Accounts Payable (AP) person, if one exists for the agency.

3. Agent/Accounts Payable (AP) options:

3a. Agent/AP need to be able to log in and print the invoice.

3b. Agent/AP need to be able to see amount due and payment history.

4. Admin options:

4a. Admin needs ability to search for list of accounts with existing balances.

4b. Ability to search for accounts with overdue balances and overdue by certain number of days.

5. Automated E-mails:

5a. 1st - monthly invoice e-mail.

5b. 15th - Reminder e-mail. Payments due on the 20th

5c. 29th - Warning e-mail. Invoice is overdue and agents will be switched to the credit card option.

6. Agent should be able to login and get an annual summary by year, of all orders placed in that calendar year.

Διαχείριση Βάσεων Δεδομένων Ηλεκτρονικό εμπόριο MySQL PHP Αρχιτεκτονική Λογισμικού

Ταυτότητα Εργασίας: #5285614

Σχετικά με την εργασία