# Drop ship template for posting url encoded string to a database. # # All field name in brakets will be replaced with the record information. # You can move or delete the field names in brakets accordingly. # # orders database table fields EntryDate=[EntryDate]&RecordID=[RecordID]&product_name=[product_name]&sku=[sku] &unit_price=[unit_price]&taxable=[taxable]&active=[active]&pictureURL=[pictureURL] &thumbnailURL=[thumbnailURL]&category=[category]&subcategory=[subcategory] &short_description=[short_description]&description=[description] &invoice_header=[invoice_header]&invoice_footer=[invoice_footer] &email_header=[email_header]&email_footer=[email_footer]&instructions=[instructions] &continue_URL=[continue_URL]&cc_email_address=[cc_email_address] &drop_ship_name=[drop_ship_name]&add_shipping=[add_shipping] &shippingfee=[shippingfee]&handlingfee=[handlingfee] &package_weight=[package_weight]&package_length=[package_length] &package_width=[package_width]&package_height=[package_height] &package_type=[package_type]&option1_text=[option1_text] &option1_list=[option1_list]&option2_text=[option2_text] &option2_list=[option2_list]&option3_text=[option3_text] &option3_list=[option3_list]&option4_text=[option4_text] &option4_list=[option4_list]&option5_text=[option5_text] &option5_list=[option5_list]&remote_id=[remote_id] &recipient_id=[recipient_id]&total=[total]&tax=[tax] &quantity=[quantity]&order_id=[order_id] &customer_id=[customer_id]&transaction_id=[transaction_id] # transaction database table fields EntryDate=[EntryDate]&RecordID=[RecordID]&bill_firstname=[bill_firstname] &bill_lastname=[bill_lastname]&bill_company=[bill_company]&bill_title=[bill_title] &bill_address1=[bill_address1]&bill_address2=[bill_address2]&bill_city=[bill_city] &bill_state=[bill_state]&bill_zipcode=[bill_zipcode]&bill_country=[bill_country] &bill_email=[bill_email]&bill_phone=[bill_phone]&bill_fax=[bill_fax] &ship_firstname=[ship_firstname]&ship_lastname=[ship_lastname] &ship_company=[ship_company]&ship_title=[ship_title]&ship_address1=[ship_address1] &ship_address2=[ship_address2]&ship_city=[ship_city]&ship_state=[ship_state] &ship_zipcode=[ship_zipcode]&ship_country=[ship_country]&ship_email=[ship_email] &ship_phone=[ship_phone]&username=[username]&password=[password]&subtotal=[subtotal] &tax=[tax]&shipping=[shipping]&handlingfee=[handlingfee]&total=[total] &transaction_type=[transaction_type]&shipping_type=[shipping_type] &paid=[paid]&date_paid=[date_paid]&date_shipped=[date_shipped] &acknowledgment_sent=[acknowledgment_sent]&advance_ship_notice=[advance_ship_notice] &customer_id=[customer_id]&order_id=[order_id]&authcode=[authcode]&refund=[refund] &status=[status]&comments=[comments]&instructions=[instructions] &recipient_address=[recipient_address]&cc_email_address=[cc_email_address]