SAP + Dotdigital
Everything you need to connect SAP and Dotdigital: how to connect, which data moves, which settings there are and what to do when something goes wrong.
- 1 data flow
1. Getting started
Prepare both systems first, then connect them in Junipeer.
- Varies by project
Prepare SAP
- Confirm the exact product and environment
- Let Junipeer confirm the auth pattern
- Create or receive the technical credentials
- Add the credentials in Junipeer
- Verify in a non-production environment first
- about 5 minutes
Prepare Dotdigital
- Open API users in Dotdigital
- Create a new API user
- Leave the generated username unchanged
- Set the password and enable the user
- Save and copy the credentials
- Paste the credentials into Junipeer
Connect and test
Enter the details in Junipeer, switch on the flows you need and test with one order before you go live.
Getting started with Junipeer
2. How the data flows
What Junipeer can move between the two systems. The arrow shows which way the data goes.
Junipeer - Customers
3. Settings
The settings you see in Junipeer, in plain words. Open one to read more. The key is the technical name.
You don't need to read them all
In Junipeer every setting has a ? that opens the same explanation next to the form, right when you need it. With the Junipeer MCP your AI assistant can also propose the settings from your own data.
How the Junipeer MCP worksSettings for SAP (21)
| Setting | What it controls | Key |
|---|---|---|
| API URL | Enter the base address of the SAP Business One API. | sap_b1_api_base_url |
| Company DB | Enter the name of the company database in SAP Business One that Junipeer should connect to. | sap_b1_ba_company_db |
| Confirm order? | Decide whether orders should be marked as confirmed when they are sent to SAP Business One. | sap_b1_order_confirmed |
| Default SAP pricelist [Export Items] | Choose the SAP Business One price list whose price is sent along with each article. | sap_b1_default_pricelist |
| Default SAP warehouse [Export Stock] | Choose the SAP Business One warehouse to use as the default when stock is exported. | sap_b1_default_warehouse |
| Default Terms of Payment in SAP | Choose the SAP Business One terms of payment to use when no payment method matches in Map Terms of Payment . | sap_b1_order_default_terms_of_payment |
| Exclude Orders created before this date | Choose a date to stop older orders from being synced. | stdintegration_filter_sap_order_created_date |
| Format for fromDate parameter in SQL query for updated stock items | Enter the date format for the fromDate parameter in the query chosen in Use SQL Query for updated stock items . | sap_b1_query_for_updated_stock_items_from_date_format |
Show all 21 settings
| Setting | What it controls | Key |
|---|---|---|
| Format for fromTime parameter in SQL query for updated stock items | Enter the time format for the fromTime parameter in the query chosen in Use SQL Query for updated stock items . | sap_b1_query_for_updated_stock_items_from_time_format |
| How many days for setting due date (default: 10)? | Enter the number of days to add to the order date to get the due date on orders in SAP Business One. | sap_b1_order_due_days |
| Map Shipping methods | Connect the shipping methods in your webshop with the shipping types in SAP Business One. | sap_b1_order_map_shipping_methods |
| Map Terms of Payment | Connect the payment methods in your webshop with the terms of payment in SAP Business One. | sap_b1_order_map_terms_of_payments |
| Map Vat percent with VatGroups | Connect the VAT percentages on orders from your webshop with the VAT groups in SAP Business One. | sap_b1_order_map_vat |
| Multiple warehouses on SAP [Export Stock]? | Decide how stock from your SAP Business One warehouses is exported. | sap_b1_multiple_warehouses |
| Only load articles which have this property set (e.g. Properties1) | Load only the SAP Business One articles (items) that have a certain property set. | sap_b1_article_filter |
| Only load customers which have this property set (e.g. U_LIFMagId) | Load only the SAP Business One customers that have a certain property set. | sap_b1_customer_filter |
| Password | Enter the password for the user in Username . | sap_b1_ba_password |
| Shipping fee Item Code | Enter the item code to use when the shipping fee is added as an order row on orders in SAP Business One. | sap_b1_order_default_shipping_article_nr |
| Use SQL Query for updated stock items | Choose a custom SQL query in SAP Business One that finds the items whose stock has changed. | sap_b1_query_for_updated_stock_items |
| Username | Enter the username Junipeer uses to log in to SAP Business One. | sap_b1_ba_username |
| What prefix is used for customer CardCode? | Enter the prefix for the customer number (CardCode) when Junipeer creates a new customer in SAP Business One. | sap_b1_order_card_code_prefix |
Settings for Dotdigital (13)
| Setting | What it controls | Key |
|---|---|---|
| Consent Attribute Fallback | Choose what happens when the customer attribute doesn't contain consent information . | dotdigital_consent_from_attribute_fallback |
| Consent Attribute Field | Enter the name of the customer attribute that holds the consent text. | dotdigital_consent_from_attribute_field |
| Consent Text | Enter the consent text that is attached to a contact when it is created or updated in Dotdigital. | dotdigital_consent_text |
| Consent URL | Enter the web address (URL) where the customer gave their consent. | dotdigital_consent_url |
| Consent from Customer Attribute | Read the consent text from a customer attribute instead of using the fixed Consent Text . | dotdigital_consent_from_attribute_enabled |
| Contact Identifier | Choose how contacts are identified in Dotdigital. | dotdigital_contact_identifier |
| Default Contact List | Choose a Dotdigital list that contacts are added to by default. | dotdigital_default_list |
| List Attribute Fallback | Choose what happens when the customer attribute doesn't contain a list ID . | dotdigital_list_from_attribute_fallback |
Show all 13 settings
| Setting | What it controls | Key |
|---|---|---|
| List Attribute Field | Enter the name of the customer attribute that holds the Dotdigital list ID(s). | dotdigital_list_from_attribute_field |
| List from Customer Attribute | Read Dotdigital list IDs from a customer attribute , instead of (or in addition to) the list settings. | dotdigital_list_from_attribute_enabled |
| Map Country to Contact List | Add contacts to a specific Dotdigital list based on their billing country . | dotdigital_list_by_country |
| Map Customer Attributes to Data Fields (Store) | Write customer attributes to Dotdigital data fields when contacts are saved. | dotdigital_map_attributes_store |
| Map Customer Fields to Data Fields (Store) | Choose which customer fields are written to Dotdigital data fields when contacts are saved. | dotdigital_map_data_fields_store |
Did this page help you?