- User Guide Home
- Installation
-
Cart Configuration
- Internal Cart Config
- Cart Columns
- Data Validation Rules
- Date / Time Setup
- Email Settings
- Status / Error Messages
- Database Config / Default Values
- Locations
- Shipping
- Item Shipping
- Tax
- Item Tax
- Item Stock
- Currency
- Discounts
- Reward Points / Vouchers
- Orders
- Database Cart Data
- Cart Functionality Config
-
Functions List
- Cart Session Data
- Cart Configuration
- Cart Item / Summary Functions
- Localisation Data
- Location Functions
- Shipping Functions
- Tax Functions
- Currency Functions
- Item Data
- Item Shipping Functions
- Item Tax Functions
- Item Stock Functions
- Discounts / Rewards / Surcharges
- Discount Functions
- Reward Point / Voucher Functions
- Surcharge Functions
- Orders / Database Cart Data
- Orders Functions
- Database Cart Data Functions
- Miscellaneous
- Customising SQL Statements
- Change Log
User Guide | Orders
When saving a customers cart data as an order, there can be a lot of data that needs to be saved.
The flexi cart save functions simplify this process by automating the cart data that is saved to the order database table, by using configurable settings via the config file.
Below is a compiled list of functions related to the carts order data.
Order User Guide Index
Order Config | Get Order Helper Data | Set Order Session Data | Order Admin DataOrder Configuration
Customise the configuration of the order database tables via the config file.
Getting Data
Get data from the carts session or database.Cart Session Data
-
order_number()
Returns the current order number. -
minimum_order()
Returns the minimum order value required for cart to checkout. -
minimum_order_status()
Returns whether a specific summary column value has surpassed the minimum required value to checkout.
Database / Helper Data
-
generate_order_number()
Generates a new order number. -
check_order_number_available()
Returns whether a specific order number is unique (Has not been used before). -
email_order()
Emails the data from a saved order to a defined recipient.
Setting Data
Set data to the carts session or database.Cart Session Data
-
set_order_number()
Set an order number. -
set_minimum_order()
Set the minimum order value.
Order Data
-
save_order()
Saves cart data and manually submitted data to the order tables. -
resave_order()
Re-saves cart data and manually submitted data from a reloaded order, to the order tables.
Admin Data
Run database management functions.Order Management Functions
-
get_refund_itemised()
Returns an itemised query of refund totals for all items that have been cancelled within an order. -
get_refund_summary()
Returns a summary of refund totals for all items that have been cancelled within an order.
Order Table CRUD Functions
-
search_orders()
SQL SELECT query via a keyword search on order summary table. -
get_db_order()
SQL SELECT query on order tables. -
get_db_order_summary()
SQL SELECT query on order summary table. -
get_db_order_detail()
SQL SELECT query on order detail table. -
update_db_order_summary()
SQL UPDATE statement on order summary table. -
update_db_order_details()
SQL UPDATE statement on order details table. -
delete_db_order()
SQL DELETE statement on order tables.
Order Status CRUD Functions
-
get_db_order_status()
SQL SELECT query on order status table. -
insert_db_order_status()
SQL INSERT statement on order status table. -
update_db_order_status()
SQL UPDATE statement on order status table. -
delete_db_order_status()
SQL DELETE statement on order status table.
Copyright © 2024, Rob Hussey, All Rights Reserved.
flexi cart was designed and developed by
