eCommerce Software

Shopping Cart Software and Complete E-Commerce Solutions

Languages English
CALL: 302.724.4517
divider

Orders System Improvement

Issue:
The order info changes in the following instances:

  1. When the Customer Address is changed
  2. When the Product Name/SKU is changed
  3. When the Product Attribute definition is changed
  4. When a product is deleted (the Orders must be deleted)

Fix:
Database changes

  1. Delete the following Foreign Key relationships from the Orders table: ShippingAddressID, BillingAddressID, ShippingMatrixID, PackagingMethodID, AdministratorID, IssuerID, CustomerID.
  2. Delete the following Foreign Key columns from the OrderItems table: ProductMatrixID, ProductID, AffiliateID, KitID.
  3. Table Orders: ShippingInfo (text). BillingInfo (text), ShippingMethod, PackagingMethod (text), CCIssuer (text), CustomerID (long)
  4. Table OrderItems: ProductMatrixDesc (text), ProductID, ProductFullName, AffiliateID, KitID

The following files were affected:


File name 		Description
components/public/Orders.cfc Function RecordOrder attribute name and Insert SQL statement changes.
Run query to retrieve the full Customer info then enter it as delimited info in the ShippingInfo (text). BillingInfo (text), columns. Run query to retrieve the credit card info then enter the full cc name in the CCIssuer columnRun query to retrieve info for ProductMatrixID and enter it in MatrixDescriptive.
Run query to retrieve info for ProductID and enter it in ProductFullName.

Function RecordOrderItems attribute name and Insert SQL statement changes.
components/public/ReturnShoppingCart.cfc Changed delimiter for product attributes in the ListShoppingCart function.
templates/default/ProcessPayment.cfm RecordOrder and RecordOrderItems method invocation parameter list changes.
admin/financial/orders/InvoiceCalculations.cfm Added parsing statements for the shipping and billing customer address.
admin/financial/orders/Invoice.cfm Renamed variables changed the product attribute loop delimiter.
admin/reports/report_elements/qry_MainReport.cfm Changed SQL in the queries affecting the Orders table.
admin/financial/orders/EmailOrder.cfm Renamed customer variables.
admin/products/DeleteProducts.cfm Removed OrderItems deletion from the routine.

 

SQL script to make this changes:

All the updated files including the SQL Alter Table script, the latest version of the Visio ERM database diagram (nice layout sacrificed due to reverse engineer operation), updated files store in their original directories, can be downloaded by logging into the customer extranet area.