Assigning Shipping and Payment Methods to Accounts
This tutorial shows how to set Allowed Shipping and Allowed Payment methods with a CSV file import or by using Bulk Actions.
Importing using a CSV file
File Format
Column Headers:
- account_name - This is required so the system knows which company to import the data to.
- account_shipping_method - Enter any allowed Shipping Methods, comma separated
- account_payment_method - Enter any allowed Payment Methods to be used at checkout, comma separated
- invoice_payment_method - Enter any allowed Payment Methods to be used to pay invoices, comma separated. Only online payment methods are allowed for Invoices, i.e. Credit Card or ACH.
| account_name | account_shipping_method | account_payment_method | account_invoice_payment_method |
|---|---|---|---|
| Sweet Home Stores | flatrate_flatrate, flatrate2_flatrate2 | purchaseorder, netterm, cashondelivery, send_bill | all |
| Yardbirds | all | all | all |
Payment Method Codes
checkmoCheck / Money OrderfreeNo Payment Information RequiredpurchaseorderPurchase OrderbanktransferBank Transfer PaymentcashondeliveryCash On DeliveryauthorizenetCredit Card (Auth.net)paypal_expressPayPal Express Checkoutpaypal_directPayPal Credit Card (Payments Pro)cryozonic_stripePay by Card (Stripe)cryozonic_achpayments_achACH Bank Account Transfer
Shipping Method Codes
Free Shipping
freeshipping_freeshipping
Flat Rate Shipping
flatrate_flatrateflatrate2_flatrate2flatrate3_flatrate3- etc...
Table Rate
tablerate_bestway
Matrix Rate
matrixrate_matrixrate
USPS Codes:
usps_0_FCLEFirst-Class Mail Large Envelopeusps_0_FCLFirst-Class Mail Letterusps_0_FCPFirst-Class Mail Parcel- `usps_0_FCPC First-Class Mail Postcards
usps_1Priority Mailusps_2Priority Mail Express Hold For Pickupusps_3Priority Mail Expressusps_4Retail Groundusps_6Media Mail Parcelusps_7Library Mail Parcelusps_13Priority Mail Express Flat Rate Envelopeusps_15First-Class Mail Large Postcardsusps_16Priority Mail Flat Rate Envelopeusps_17Priority Mail Medium Flat Rate Boxusps_22Priority Mail Large Flat Rate Boxusps_23Priority Mail Express Sunday/Holiday Deliveryusps_25Priority Mail Express Sunday/Holiday Delivery Flat Rate Envelopeusps_27Priority Mail Express Flat Rate Envelope Hold For Pickupusps_28Priority Mail Small Flat Rate Boxusps_29Priority Mail Padded Flat Rate Envelopeusps_30Priority Mail Express Legal Flat Rate Envelopeusps_31Priority Mail Express Legal Flat Rate Envelope Hold For Pickupusps_32Priority Mail Express Sunday/Holiday Delivery Legal Flat Rate Envelopeusps_33Priority Mail Hold For Pickupusps_34Priority Mail Large Flat Rate Box Hold For Pickupusps_35Priority Mail Medium Flat Rate Box Hold For Pickupusps_36Priority Mail Small Flat Rate Box Hold For Pickupusps_37Priority Mail Flat Rate Envelope Hold For Pickupusps_38Priority Mail Gift Card Flat Rate Envelopeusps_39Priority Mail Gift Card Flat Rate Envelope Hold For Pickupusps_40Priority Mail Window Flat Rate Envelopeusps_41Priority Mail Window Flat Rate Envelope Hold For Pickupusps_42Priority Mail Small Flat Rate Envelopeusps_43Priority Mail Small Flat Rate Envelope Hold For Pickupusps_44Priority Mail Legal Flat Rate Envelopeusps_45Priority Mail Legal Flat Rate Envelope Hold For Pickupusps_46Priority Mail Padded Flat Rate Envelope Hold For Pickupusps_47Priority Mail Regional Rate Box Ausps_48Priority Mail Regional Rate Box A Hold For Pickupusps_49Priority Mail Regional Rate Box Busps_50Priority Mail Regional Rate Box B Hold For Pickupusps_53First-Class Package Service Hold For Pickupusps_57Priority Mail Express Sunday/Holiday Delivery Flat Rate Boxesusps_58Priority Mail Regional Rate Box Cusps_59Priority Mail Regional Rate Box C Hold For Pickupusps_61First-Class Package Serviceusps_62Priority Mail Express Padded Flat Rate Envelopeusps_63Priority Mail Express Padded Flat Rate Envelope Hold For Pickupusps_64Priority Mail Express Sunday/Holiday Delivery Padded Flat Rate Envelopeusps_INT_1Priority Mail Express Internationalusps_INT_2Priority Mail Internationalusps_INT_4Global Express Guaranteed (GXG)usps_INT_5Global Express Guaranteed Documentusps_INT_6Global Express Guaranteed Non-Document Rectangularusps_INT_7Global Express Guaranteed Non-Document Non-Rectangularusps_INT_8Priority Mail International Flat Rate Envelopeusps_INT_9Priority Mail International Medium Flat Rate Boxusps_INT_10Priority Mail Express International Flat Rate Envelopeusps_INT_11Priority Mail International Large Flat Rate Boxusps_INT_12USPS GXG Envelopesusps_INT_13First-Class Mail International Letterusps_INT_14First-Class Mail International Large Envelopeusps_INT_15First-Class Package International Serviceusps_INT_16Priority Mail International Small Flat Rate Boxusps_INT_17Priority Mail Express International Legal Flat Rate Envelopeusps_INT_18Priority Mail International Gift Card Flat Rate Envelopeusps_INT_19Priority Mail International Window Flat Rate Envelopeusps_INT_20Priority Mail International Small Flat Rate Envelopeusps_INT_21First-Class Mail International Postcardusps_INT_22Priority Mail International Legal Flat Rate Envelopeusps_INT_23Priority Mail International Padded Flat Rate Envelopeusps_INT_24Priority Mail International DVD Flat Rate priced boxusps_INT_25Priority Mail International Large Video Flat Rate priced boxusps_INT_27Priority Mail Express International Padded Flat Rate Envelope
FedEx Codes
fedex_EUROPE_FIRST_INTERNATIONAL_PRIORITYfedex_FEDEX_1_DAY_FREIGHTfedex_FEDEX_2_DAY_FREIGHTfedex_FEDEX_2_DAYfedex_FEDEX_2_DAY_AMfedex_FEDEX_3_DAY_FREIGHTfedex_FEDEX_EXPRESS_SAVERfedex_FEDEX_GROUNDfedex_FIRST_OVERNIGHTfedex_GROUND_HOME_DELIVERYfedex_INTERNATIONAL_ECONOMYfedex_INTERNATIONAL_ECONOMY_FREIGHTfedex_INTERNATIONAL_FIRSTfedex_INTERNATIONAL_GROUNDfedex_INTERNATIONAL_PRIORITYfedex_INTERNATIONAL_PRIORITY_FREIGHTfedex_PRIORITY_OVERNIGHTfedex_SMART_POSTfedex_STANDARD_OVERNIGHTfedex_FEDEX_FREIGHTfedex_FEDEX_NATIONAL_FREIGHT
Importing
To import your Shipping and Payment Methods, go to Accounts > Account List and click on the Importer icon between the Advanced Search and Bulk Actions.
You may Drag and Drop or Browse and upload your CSV file.
Note about Append vs. Replace"Append Company Data" will not remove shipping and payment methods that are not included in the CSV file. To remove all but the shipping and payment methods in the file, use "Replace Company Data"
Updating using Bulk Actions
You may update your Accounts' allowed Shipping methods or Payment methods from the Accounts list using Bulk Actions.
Select Update Payment Methods, Update Invoice Payment Methods > Allow all Payment Methods for this Location= No if you want to select specific methods.
Update Invoice Payment Methods will only list online payment methods such as Credit Card, ACH or PayPal.
Update Shipping Methods > Allow all Shipping Methods for this Location= No if you want to select specific methods.
Updated 6 months ago