Working with Customize the Shopping Cart, Check Out Order, Shipping Cost
Let you customize the Pay Pal, setup the Check Out Fill Info form, the Shopping Cart
Table x_shop_property

• The table contains all details to customize the Pay Pal payment, and the Check out Fill Info form


Picture: Table x_shop_property allows you to customize the Check-out Fill Info screen, Shopping Cart and Pay Pal
X_SHOP_ PROPERTY DESCRIPTION
* NAME Is the Key. You use the same name = my_shop or create new record named mystore.com. But there is only one record (one row) in this table.
* COUNTRY Enter the code name of your country, such as Canada = CA. Check standard international code. It is used by Pay Pal shopping cart.
* EMAIL_PAYMENT_ACT Enter the email account you use to register Pay Pal account. It is used by Pay Pal shopping Cart.
* DOMAIN The domain name of your website. Example: www.myshop.com. It is used by Pay Pal shopping Cart.
* CURRENCY The currency of your country, such as: CAD for Canada. Check standard international code. It is used by Pay Pal shopping Cart.
* LOGO_URL The Url web address of the logo used by Pay Pal shopping cart. It is used by Pay Pal to display your Logos on its check-out page.  See sample of Url of Logos.
PP_LOGO_BGCOLOR The background color of your Logo on Pay Pal check out screens. If there is logo, the logo on the top of the background color.
* MAP_URL The path folder of the MAP pic of business location. Used for direction of business, or the MAP of the local area delivery of restaurant so that the customers know where locally you can delivery.
NOTE Example, GOOGLE your address. Save the map as  com_map.jpg on the remote folder /myweb/. Then enable IS_SHOW_MAP field.
* SHIPPING_PRIORITY Let you create a list of shipping that you provide. In this example, to provide shipping = Air, Normal, Fast, you enter in this box a string: Air, Normal, Fast. In the Check Out Fill Info form, it will display a pull down option list of shipping that customer will choose one of them.
NOTE: If you don't enter any thing, the [Shipping Priority] becomes a box ( not a list) that lets customers enter their own shipping service.
See below picture.
*AREACODE_DELIVERY The same as SHIPPING_PRIORITY. Let you create a list of AREA CODE of DELIVERY that you want to deliver. This is for case like restaurant, you can't deliver far than where you locate. In this example, to provide  area code of delivery = M2A 1B5, M3G 1A6, you enter in this box a string: M2A 1B5, M3G 1A6. In the Check Out Fill Info form, it will display a pull down option list of delivery area code ( or district like: North York, Brampton, South York).
NOTE: If you don't enter any thing, then the [Check local delivery] becomes a box ( not a pull down list) that let customers enter their area code of delivery. See below picture.
 
TAX1_GST_PERCENTAGE Enter a decimal number percentage tax for GST = 5% or 0.05 ( Federal tax in Canada) or TAX1 in other country. If not applied then enter 0.0 or leave it blank. When customer buy, it will apply in the Total Tax in shopping cart. f there is an exempt in table x_customer field = Tax1_Gst_Exempt then this number will not applied for that customer.
TAX2_PST_PERCENTAGE Enter a decimal number percentage tax for PST = 8% or 0.08 ( = Provincial tax in Canada) or TAX2 in other country. If not applied then enter 0.0 or leave it blank. When customer buy, it will apply in the Total Tax in shopping cart. If there is an exempt in table x_customer field = Tax2_Pst_Exempt then this number will not applied for that customer.
IS_PO_NUMBER Select = yes or no to turn on or off the [PO Number] input box in the Check-Out Fill Info form.
IS_DELIVERY_TIP Customer enters tip for driver like restaurant delivery. Select = yes or no to turn on or off the [Delivery Tip] input box in the Check-Out Fill Info form.
IS_AREACODE_CHECK Used for restaurant to set up limited local delivery. Select = yes or no to turn on or off the [* Check local delivery] input box in the Check-Out Fill Info form. If select no, it is replaced by an input named  [* Area code] used for customer enter the area code of delivery address. (See above picture)
IS_ONLINE_BANKING If this payment, the customer will logins into their online banking and pay. Select = yes or no to turn on or off the [Online Banking] payment option list box in the Check-Out Fill Info form.
IS_PP_CREDIT If select this payment, the customer will use Pay Pal to pay. Select = yes or no to turn on or off the [Pay Pal Credit ] payment option list box in the Check-Out Fill Info form. If turn off, the customer will not be able to pay by Pay Pal using credit card.
IS_QUOTE If select Get Quote, after check-out, customer will receive an email with instruction to login and click on Order History in order to check quote and order if accepted. Select = yes or no to turn on or off the [Get Quote ] payment option in list box [Pay By]. To set up email instruction, open x_email_manager. Select ETYPE = quote. Then edit the Emessage field. See HOW TO GET QUOTE.
IS_CASH If select this payment, customer pays by cash for delivery like restaurant. Select = yes or no to turn on or off the [Cash] in list [Paid_By].
IS_BILL_ME_LATER If select this payment, customer is granted to pay later when receiving invoice. Select = yes or no to turn on or off the [Cash] in list [Paid_By].
IS_CHECK If select this payment, customer is granted to pay by check. Select = yes or no to turn on or off the [Cash] in list [Paid_By].
IS_CREDIT If select this payment, customer paid by using credit card. Select = yes or no to turn on or off the [Credit] in list [Paid_By].
 
IS_EXTRANOTE_SHOPPINGCART It is extra field for customer to enter extra notes, or comments, or adds on, or coupon for each item order on the shopping cart. For example, "- Cook not well done." for food delivery, or customer enter coupon name in this input= "CP31900". When click on button [UPDATE], it will connect to table x_coupon table in database and subtract the price.
 
Picture: Enable column [Extra Notes - Coupon] in shopping cart. Customer enters the coupon = CP2190 in any row of column [Extra Notes - Coupon]. Then click on button [Update] to get price discounted. The Shopping Cart connects to table x_coupon, retrieve the coupon price = 5.0$. This noodle soup original costs 6.0$.
* IS_SHOW_MAP Show the map of your company location on the Check-out Fill Info Form screen.
* IS_SHOW_LAST_ORDER Show the last order of exist member on the Check-out Fill Info Form screen.
CAL_SHIPPING_COST Select one of the following shipping cost:
1) Based On Flat Rate of total order: such as: Total order from 1 - 10$ => Shipping cost = 2.0$, 11.0$ - 50.0$ => Fee= 5.0$ ... so on. You need to setup in the table x_ship1_property
2) Based On Percentage of total order: such as: Total order from 1 - 10$ => Shipping cost = 2.0%, 11.0$ - 50.0$ => Fee= 5.0% ... so on. You need to setup in the table x_ship1_property
3) Based On Total Weight: such as: Total weight from order from 1 - 10 lbs => Shipping cost = 2.0$, 11.0 - 50.0 lbs => Fee= 5.0$ ... so on. You need to setup in the table x_ship2_property.
You may want to provide Free Shipping for customers
whose orders are high volume, such as flat rate = 0.0 for total orders ranges from 50.000$ - 500.000$
See HOW-TO SETUP AND CALCULATE SHIPPING COST  

Picture: The Check-out Fill Info Form screen with all options enable. One step, one screen Check-out.
Conclusion
Table x_shop_property lets you customize the Check-out Fill Info screen. Enable or disable field Extra Note, Coupon in Shopping Cart. Select Calculation of Shipping Cost.
Customer can enter coupon in any row under column [Extra Notes - Coupon] then update to get coupon price. They also use this input box to enter extra notes for that ordered product item.