Learn more
Guides

Shopify Exporter

v0.0.0

📘

The Shopify Bulk API documentation can be accessed here

🚧

Important Note on Data Management

  • We recommend testing this connector using credentials from a staging environment to ensure data flows as intended. Given that the reports can overwrite existing data or create new entries, please proceed with caution when executing them to prevent any unintended changes.

Set up

To configure the Shopify Exporter connector, ensure you have the following credentials available:

For Shopify Exporter (GraphQL - Token):

  • Personal Access Token (PAT)
  • Shop Name: Do not include https:// or .myshopify.com.

Alternatively, for Shopify Exporter (GraphQL - Client):

  • Client ID
  • Client Secret
  • Shop Name: Do not include https:// or .myshopify.com.

Features

FeatureSupportNotes
API reliability🟢Reliable

Reports detail

⬇️ Report🔑 Incremental key🔑 Primary key📄 Link to API endpoint
Company (Assign Customer As Contact)N/AN/ACompany Assign Customer As Contact
Company (Create)N/AN/ACompany Create
Company (Remove Contact)N/AN/ACompany Contact Remove From Company
Company (Update)N/AN/ACompany Update
Company (Update Contact)N/AN/ACompany Contact Update
Company Location (Assign Roles)N/AN/ACompany Location Assign Roles
Company Location (Create)N/AN/ACompany Location Create
Company Location (Revoke Roles)N/AN/ACompany Location Revoke Roles
Company Location (Update)N/AN/ACompany Location Update
Customer (Create)N/AN/ACustomer Create
Customer (Update)N/AN/ACustomer Update
Metafields SetN/AN/AMetafieldsSet
Orders (Add tags)N/AN/ATags Add
Orders (Remove tags)N/AN/ATags Remove
Store Credit Account CreditN/AN/AStore Credit Account Credit
Store Credit Account DebitN/AN/AStore Credit Account Debit

Input Table Format

Company Assign Customer as Contact Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_COMPANY_ASSIGN_CUSTOMER_AS_CONTACT (
    companyid   VARCHAR NOT NULL,
    customerid  VARCHAR NOT NULL  
);

INSERT INTO SHOPIFY_COMPANY_ASSIGN_CUSTOMER_AS_CONTACT (companyid, customerid)
VALUES
('gid://shopify/Company/9243xxxxx0','gid://shopify/Customer/8243xxxxx0'),
('gid://shopify/Company/9243xxxxx1','gid://shopify/Customer/8243xxxxx1'),
('gid://shopify/Company/9243xxxxx2','gid://shopify/Customer/8243xxxxx2'),
('gid://shopify/Company/9243xxxxx3','gid://shopify/Customer/8243xxxxx3'),
('gid://shopify/Company/9243xxxxx4','gid://shopify/Customer/8243xxxxx4');
Company Create Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_COMPANY_CREATE (
    input  VARCHAR NOT NULL
);

INSERT INTO SHOPIFY_COMPANY_CREATE (input)
VALUES
    ('{"company":{"name":"Test Company C --- Company Only","externalId":"TEST-C"}}'),
    ('{"company":{"name":"Test Company D --- Full CompanyInput","externalId":"TEST-D","note":"Company-only row, all CompanyInput fields","customerSince":"2021-03-01T00:00:00Z"}}'),
    ('{"company":{"name":"Test Company E","externalId":"TEST-E"},"companyLocation":{"name":"Test Site E1 --- London","externalId":"TEST-E1-LON","shippingAddress":{"address1":"1 Finsbury Avenue","city":"London","zoneCode":"ENG","zip":"EC2M 2PF","countryCode":"GB"},"billingSameAsShipping":true}}'),
    ('{"company":{"name":"Test Company F","externalId":"TEST-F"},"companyLocation":{"name":"Test Site F1 --- Manchester","externalId":"TEST-F1-MAN","shippingAddress":{"address1":"2 St Peter''s Square","city":"Manchester","zoneCode":"ENG","zip":"M2 3AE","countryCode":"GB"},"billingSameAsShipping":true},"companyContact":{"email":"[email protected]","firstName":"Frankie","lastName":"Okafor","title":"Procurement Lead","phone":"+441611234503","locale":"en"}}');
Company Contact Remove From Company Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_COMPANY_CONTACT_REMOVE (
    companycontactid VARCHAR NOT NULL
);
INSERT INTO SHOPIFY_COMPANY_CONTACT_REMOVE VALUES
   ('gid://shopify/CompanyContact/6243xxxxx0'),
    ('gid://shopify/CompanyContact/6243xxxxx1'),
    ('gid://shopify/CompanyContact/6243xxxxx2');
Company Update Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_COMPANY_UPDATE (
    companyid  VARCHAR NOT NULL, 
    input      VARCHAR NOT NULL
);
-- only allows 3 fields to be updated (name, externalId and note) 
INSERT INTO TRANSFORM_TEST.TESTING.SHOPIFY_COMPANY_UPDATE (companyid, input)
VALUES
    ('gid://shopify/Company/9043xxxxx0', '{"note":"CU1 probe --- note-only update 2026-10-28"}'),
    ('gid://shopify/Company/9043xxxxx1', '{"name":"Test Company E --- renamed"}'),
    ('gid://shopify/Company/9043xxxxx2','{"note":"Note-only update 2026-10-28"}'),
    ('gid://shopify/Company/9043xxxxx3', '{"name":"Test Company J --- refreshed","note":"Full record refresh 2026-10-28"}');
Company Contact Update Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_COMPANY_CONTACT_UPDATE (
    companycontactid  VARCHAR NOT NULL,
    input             VARCHAR NOT NULL  
);

INSERT INTO SHOPIFY_COMPANY_CONTACT_UPDATE (companycontactid, input)
VALUES
    ('gid://shopify/CompanyContact/6143xxxxx0',
     '{"title":"CC1 probe --- title-only update 2026-10-28"}'),
    ('gid://shopify/CompanyContact/6143xxxxx1',
     '{"email":"[email protected]"}'),
    ('gid://shopify/CompanyContact/6143xxxxx2',
     '{"locale":"en-GB"}'),
    ('gid://shopify/CompanyContact/6143xxxxx3',
     '{"firstName":"Frankie","lastName":"Okafor-Reid","title":"Head of Procurement","phone":"+441611234599","locale":"en-GB"}');
Company Location Assign Roles Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_COMPANY_LOCATION_ASSIGN_ROLES (
    companylocationid  VARCHAR NOT NULL,
    rolestoassign      VARCHAR NOT NULL   
);

INSERT INTO SHOPIFY_COMPANY_LOCATION_ASSIGN_ROLES VALUES
    ('gid://shopify/CompanyLocation/6243xxxxx7',
'[{"companyContactId":"gid://shopify/CompanyContact/6243xxxxx8","companyContactRoleId":"gid://shopify/CompanyContactRole/6243xxxxx9"},{"companyContactId":"gid://shopify/CompanyContact/5243xxxxx0","companyContactRoleId":"gid://shopify/CompanyContactRole/5243xxxxx1"}]'),

    ('gid://shopify/CompanyLocation/5243xxxxx2',
'[{"companyContactId":"gid://shopify/CompanyContact/5243xxxxx3","companyContactRoleId":"gid://shopify/CompanyContactRole/5243xxxxx4"}]'),

    ('gid://shopify/CompanyLocation/5243xxxxx6',
'[{"companyContactId":"gid://shopify/CompanyContact/5243xxxxx7","companyContactRoleId":"gid://shopify/CompanyContactRole/5243xxxxx8"}]');
Company Location Create Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_COMPANY_LOCATION_CREATE (
    companyid  VARCHAR NOT NULL,
    input      VARCHAR NOT NULL 
);

INSERT INTO SHOPIFY_COMPANY_LOCATION_CREATE (companyid, input)
VALUES
    ('gid://shopify/Company/8043xxxxx0',
     '{"name":"Test Site E2 --- Glasgow","externalId":"TEST-E2-GLA","shippingAddress":{"address1":"110 Queen Street","city":"Glasgow","zoneCode":"SCT","zip":"G1 3BX","countryCode":"GB"},"billingSameAsShipping":true}'),

    ('gid://shopify/Company/8043xxxxx1',
     '{"name":"Test Site I2 --- Newcastle","externalId":"TEST-I2-NCL","shippingAddress":{"firstName":"Nadia","lastName":"Iqbal","address1":"55 Degrees North","address2":"Pilgrim Street","city":"Newcastle upon Tyne","zoneCode":"ENG","zip":"NE1 6BF","countryCode":"GB"},"billingAddress":{"address1":"PO Box 118","city":"Newcastle upon Tyne","zoneCode":"ENG","zip":"NE1 1AA","countryCode":"GB"},"billingSameAsShipping":false}'),

    ('gid://shopify/Company/8043xxxxx0',
     '{"name":"Test Site J2 --- Sheffield","externalId":"TEST-J2-SHE","shippingAddress":{"address1":"1 St Paul''s Place","city":"Sheffield","zoneCode":"ENG","zip":"S1 2JE","countryCode":"GB"},"billingSameAsShipping":true,"taxExempt":true,"taxRegistrationId":"GB123456789"}'),

    ('gid://shopify/Company/9043xxxxx0',
     '{"name":"Test Site M2 --- Nottingham","externalId":"TEST-M2-NTG","phone":"+441151234508","note":"Dock 2, appointment required","locale":"en","shippingAddress":{"firstName":"Morgan","lastName":"Idowu","address1":"1 Castle Quay","address2":"Unit 4","city":"Nottingham","zoneCode":"ENG","zip":"NG7 1FW","countryCode":"GB"},"billingAddress":{"address1":"30 Maid Marian Way","city":"Nottingham","zoneCode":"ENG","zip":"NG1 6HS","countryCode":"GB"},"billingSameAsShipping":false,"taxExempt":false,"taxRegistrationId":"GB987654321","buyerExperienceConfiguration":{"checkoutToDraft":true,"editableShippingAddress":false}}');
Company Location Revoke Roles Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_COMPANY_LOCATION_REVOKE_ROLES (
    companylocationid  VARCHAR NOT NULL, 
    rolestorevoke      VARCHAR NOT NULL 
);

INSERT INTO SHOPIFY_COMPANY_LOCATION_REVOKE_ROLES VALUES
('gid://shopify/CompanyLocation/4243xxxxx2','["gid://shopify/CompanyContactRoleAssignment/243xxxxx2"]');
Company Location Update Table Snippet
CREATE OR REPLACE TABLE TRANSFORM_TEST.TESTING.SHOPIFY_COMPANY_LOCATION_UPDATE (
    companylocationid  VARCHAR NOT NULL, 
    input              VARCHAR NOT NULL 
);

INSERT INTO TRANSFORM_TEST.TESTING.SHOPIFY_COMPANY_LOCATION_UPDATE (companylocationid, input)
VALUES
     ('gid://shopify/CompanyLocation/6043xxxxx0',
     '{"note":"Credit terms renegotiated 2026-10"}'),
    ('gid://shopify/CompanyLocation/6043xxxxx1',
     '{"phone":"+15145550199","note":"Relocated Q4 2026"}'),
    ('gid://shopify/CompanyLocation/6043xxxxx2',
     '{"externalId":"ACME-0001-OTT-V2"}'),
    ('gid://shopify/CompanyLocation/6043xxxxx3',
     '{"name":"Montreal Branch -updated","externalId":"ACME-0001-MTL","phone":"+15145550100","note":"Primary Quebec site","locale":"fr-CA"}'),
    ('gid://shopify/CompanyLocation/6043xxxxx4',
     '{"buyerExperienceConfiguration":{"checkoutToDraft":true,"editableShippingAddress":false}}');
Customer Create Table Snippet

CREATE OR REPLACE TABLE SHOPIFY_CUSTOMER_CREATE (
    input VARCHAR NOT NULL
);

INSERT INTO SHOPIFY_CUSTOMER_CREATE (input)
VALUES    ('{"email":"[email protected]","phone":"+16465555555","firstName":"Steve","smsMarketingConsent":{"marketingState":"SUBSCRIBED","marketingOptInLevel":"SINGLE_OPT_IN"}}'),
('{"email":"[email protected]","phone":"+16465555556","firstName":"Steve","lastName":"Lastname","emailMarketingConsent":{"marketingOptInLevel":"CONFIRMED_OPT_IN","marketingState":"SUBSCRIBED"}}'),
    ('{"email":"[email protected]","metafields":[{"namespace":"my_field","key":"nickname","type":"single_line_text_field","value":"rob"}]}'),
    ('{"email":"[email protected]"}'),
    ('{"email":"[email protected]","tags":["wholesale","vip"],"note":"Imported 2026-10","taxExempt":true}');
Customer Update Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_CUSTOMER_UPDATE (
    input  VARCHAR NOT NULL
);

INSERT INTO SHOPIFY_CUSTOMER_UPDATE (input)
VALUES
    ('{"id":"gid://shopify/Customer/9243xxxxx0","firstName":"Joe"}'),
    ('{"id":"gid://shopify/Customer/9243xxxxx1","emailMarketingConsent":{"marketingState":"UNSUBSCRIBED"}}'),
    ('{"id":"gid://shopify/Customer/9243xxxxx2","tags":["returning"],"note":"Multi-field update 2026-10-27"}'),
    ('{"id":"gid://shopify/Customer/9243xxxxx3","metafields":[{"namespace":"my_field","key":"nickname","type":"single_line_text_field","value":"catherine"}]}');
Metafields Set Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_METAFIELDS_SET (
    metafields  VARCHAR NOT NULL  
);

INSERT INTO SHOPIFY_METAFIELDS_SET (metafields)
VALUES
    ('[{"ownerId":"gid://shopify/Customer/8243xxxxx0","key":"app_flag","type":"single_line_text_field","value":"namespace omitted on purpose"}]'),
    ('[{"ownerId":"gid://shopify/Customer/8243xxxxx1","namespace":"loyalty","key":"tier","type":"single_line_text_field","value":"platinum"},{"ownerId":"gid://shopify/Customer/8243xxxxx2","namespace":"loyalty","key":"tier","type":"single_line_text_field","value":"gold"},{"ownerId":"gid://shopify/Customer/8243xxxxx3","namespace":"loyalty","key":"tier","type":"single_line_text_field","value":"silver"}]'),
('[{"ownerId":"gid://shopify/Customer/8243xxxxx4","namespace":"loyalty","key":"first_seen","type":"single_line_text_field","value":"2026-10-30","compareDigest":null}]'),
    ('[{"ownerId":"gid://shopify/Customer/8243xxxxx5","namespace":"bulk","key":"probe_00","type":"number_integer","value":"0"},{"ownerId":"gid://shopify/Customer/8243xxxxx6","namespace":"bulk","key":"probe_01","type":"number_integer","value":"1"},{"ownerId":"gid://shopify/Customer/8243xxxxx7","namespace":"bulk","key":"probe_02","type":"number_integer","value":"2"},{"ownerId":"gid://shopify/Company/7243xxxxx0","namespace":"bulk","key":"probe_03","type":"number_integer","value":"3"},{"ownerId":"gid://shopify/Company/7243xxxxx1","namespace":"bulk","key":"probe_04","type":"number_integer","value":"4"},{"ownerId":"gid://shopify/CompanyLocation/7243xxxxx2","namespace":"bulk","key":"probe_05","type":"number_integer","value":"5"},{"ownerId":"gid://shopify/CompanyLocation/7243xxxxx3","namespace":"bulk","key":"probe_06","type":"number_integer","value":"6"},{"ownerId":"gid://shopify/Customer/7243xxxxx4","namespace":"bulk","key":"probe_07","type":"number_integer","value":"7"},{"ownerId":"gid://shopify/Customer/7243xxxxx5","namespace":"bulk","key":"probe_08","type":"number_integer","value":"8"},{"ownerId":"gid://shopify/Customer/7243xxxxx6","namespace":"bulk","key":"probe_09","type":"number_integer","value":"9"},{"ownerId":"gid://shopify/Company/7243xxxxx7","namespace":"bulk","key":"probe_10","type":"number_integer","value":"10"},{"ownerId":"gid://shopify/Company/7243xxxxx8","namespace":"bulk","key":"probe_11","type":"number_integer","value":"11"},{"ownerId":"gid://shopify/CompanyLocation/6243xxxxx0","namespace":"bulk","key":"probe_12","type":"number_integer","value":"12"},{"ownerId":"gid://shopify/CompanyLocation/6243xxxxx1","namespace":"bulk","key":"probe_13","type":"number_integer","value":"13"},{"ownerId":"gid://shopify/Customer/6243xxxxx2","namespace":"bulk","key":"probe_14","type":"number_integer","value":"14"},{"ownerId":"gid://shopify/Customer/6243xxxxx3","namespace":"bulk","key":"probe_15","type":"number_integer","value":"15"},{"ownerId":"gid://shopify/Customer/6243xxxxx4","namespace":"bulk","key":"probe_16","type":"number_integer","value":"16"},{"ownerId":"gid://shopify/Company/6243xxxxx5","namespace":"bulk","key":"probe_17","type":"number_integer","value":"17"},{"ownerId":"gid://shopify/Company/6243xxxxx6","namespace":"bulk","key":"probe_18","type":"number_integer","value":"18"},{"ownerId":"gid://shopify/CompanyLocation/2243xxxxx0","namespace":"bulk","key":"probe_19","type":"number_integer","value":"19"},{"ownerId":"gid://shopify/CompanyLocation/2243xxxxx1","namespace":"bulk","key":"probe_20","type":"number_integer","value":"20"},{"ownerId":"gid://shopify/Customer/2243xxxxx2","namespace":"bulk","key":"probe_21","type":"number_integer","value":"21"},{"ownerId":"gid://shopify/Customer/2243xxxxx3","namespace":"bulk","key":"probe_22","type":"number_integer","value":"22"},{"ownerId":"gid://shopify/Customer/2243xxxxx4","namespace":"bulk","key":"probe_23","type":"number_integer","value":"23"},{"ownerId":"gid://shopify/Company/2243xxxxx5","namespace":"bulk","key":"probe_24","type":"number_integer","value":"24"}]'),
    ('[{"ownerId":"gid://shopify/Customer/2243xxxxx6","namespace":"loyalty","key":"tier","type":"single_line_text_field","value":"gold"},{"ownerId":"gid://shopify/Customer/3243xxxxx0","namespace":"loyalty","key":"tier","type":"single_line_text_field","value":"silver"},{"ownerId":"gid://shopify/Customer/3243xxxxx1","namespace":"loyalty","key":"tier","type":"single_line_text_field","value":"bronze"}]'),
    ('[{"ownerId":"gid://shopify/Company/3243xxxxx2","namespace":"erp","key":"account_code","type":"single_line_text_field","value":"TEST-A"},{"ownerId":"gid://shopify/Company/3243xxxxx3","namespace":"erp","key":"account_code","type":"single_line_text_field","value":"TEST-B"},{"ownerId":"gid://shopify/CompanyLocation/3243xxxxx4","namespace":"ops","key":"site_code","type":"single_line_text_field","value":"TEST-A-SITE-1"},{"ownerId":"gid://shopify/CompanyLocation/3243xxxxx5","namespace":"ops","key":"site_code","type":"single_line_text_field","value":"TEST-B-SITE-1"}]');
Tags Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_TAGS_DATA (
    id VARCHAR  NOT NULL,
    tags VARCHAR  NOT NULL
);

INSERT INTO SHOPIFY_TAGS_DATA (id, tags)
VALUES 
   ('gid://shopify/Order/5043xxxxx0','["good"]'),
   ('gid://shopify/Order/5043xxxxx1','["active", "ready"]'),
   ('gid://shopify/Order/5043xxxxx2','["ready", "active"]'),
   ('gid://shopify/Order/5043xxxxx3','["progress", "inactive"]'),
   ('gid://shopify/Order/5043xxxxx4','["cancelled"]'),
   ('gid://shopify/Order/5043xxxxx5','["alright", "inactive"]'),
   ('gid://shopify/Order/5043xxxxx6','["cancelled", "inactive", "processed"]'),
   ('gid://shopify/Order/5043xxxxx7','["processed", "inactive"]'),
   ('gid://shopify/Order/5043xxxxx8','["ready", "active"]'),
   ('gid://shopify/Order/5043xxxxx9','["active"]'),
   ('gid://shopify/Order/5043xxxx10','["incomplete"]');
StoreCreditAccountCredit Table Snippet
CREATE OR REPLACE TABLE STORE_CREDIT_ACCOUNT_CREDIT (
    id           VARCHAR NOT NULL,
    creditinput  VARCHAR NOT NULL
);

INSERT INTO TRANSFORM_TEST.TESTING.SHOPIFY_STORE_CREDIT_ACCOUNT_CREDIT (id, creditinput)
VALUES
    ('gid://shopify/StoreCreditAccount/4043xxxxx0',
     '{"creditAmount":{"amount":"149.99","currencyCode":"GBP"}}'),
    ('gid://shopify/StoreCreditAccount/4043xxxxx1',
     '{"creditAmount":{"amount":"205.00","currencyCode":"GBP"}}'),
    ('gid://shopify/StoreCreditAccount/4043xxxxx2',
     '{"creditAmount":{"amount":"90.00","currencyCode":"GBP"},"expiresAt":"2026-12-24"}');

-- ---------------------------------------------------------------------
-- 2. Using Customer IDs
-- ---------------------------------------------------------------------
CREATE OR REPLACE TABLE STORE_CREDIT_ACCOUNT_CREDIT_CUSTOMER_GID (
    id           VARCHAR NOT NULL,
    creditinput  VARCHAR NOT NULL
);

INSERT INTO STORE_CREDIT_ACCOUNT_CREDIT_CUSTOMER_GID (id, creditinput)
VALUES
    ('gid://shopify/Customer/3043xxxxx0',
     '{"creditAmount":{"amount":"20.01","currencyCode":"GBP"}}'),
    ('gid://shopify/Customer/4043xxxxx1',
     '{"creditAmount":{"amount":"40.01","currencyCode":"GBP"},"expiresAt":"2027-10-21T23:59:59Z"}'),
    ('gid://shopify/Customer/4043xxxxx2',
     '{"creditAmount":{"amount":"7.01","currencyCode":"GBP"},"expiresAt":"2027-11-21T23:59:59Z"}');

-- ---------------------------------------------------------------------
-- 3. Using Companylocation IDs
-- ---------------------------------------------------------------------
CREATE OR REPLACE TABLE STORE_CREDIT_ACCOUNT_CREDIT_COMPANYLOCATION_GID (
    id           VARCHAR NOT NULL,
    creditinput  VARCHAR NOT NULL
);

INSERT INTO STORE_CREDIT_ACCOUNT_CREDIT_COMPANYLOCATION_GID (id, creditinput)
VALUES
    ('gid://shopify/CompanyLocation/2043xxxxx0',
     '{"creditAmount":{"amount":"10.01","currencyCode":"GBP"}}'),
    ('gid://shopify/CompanyLocation/3043xxxxx1',
     '{"creditAmount":{"amount":"15.01","currencyCode":"GBP"},"expiresAt":"2027-10-21T23:59:59Z"}');
StoreCreditAccountDebit Table Snippet
CREATE OR REPLACE TABLE SHOPIFY_STORE_CREDIT_ACCOUNT_DEBIT (
    id          VARCHAR NOT NULL,
    debitinput  VARCHAR NOT NULL
);

INSERT INTO SHOPIFY_STORE_CREDIT_ACCOUNT_DEBIT (id, debitinput)
VALUES
    ('gid://shopify/StoreCreditAccount/3043xxxxx0',
     '{"debitAmount":{"amount":"1.00","currencyCode":"GBP"}}'),
    ('gid://shopify/StoreCreditAccount/3043xxxxx1',
     '{"debitAmount":{"amount":"0.50","currencyCode":"GBP"}}'),
    ('gid://shopify/StoreCreditAccount/3043xxxxx2',
     '{"debitAmount":{"amount":"0.01","currencyCode":"GBP"}}');

-- ---------------------------------------------------------------------
-- 2. Using Customer IDs
-- ---------------------------------------------------------------------
CREATE OR REPLACE TABLE SHOPIFY_STORE_CREDIT_ACCOUNT_DEBIT_CUSTOMER_GID (
    id          VARCHAR NOT NULL,
    debitinput  VARCHAR NOT NULL
);

INSERT INTO SHOPIFY_STORE_CREDIT_ACCOUNT_DEBIT_CUSTOMER_GID (id, debitinput)
VALUES
    ('gid://shopify/Customer/2043xxxxx0',
     '{"debitAmount":{"amount":"201.00","currencyCode":"GBP"}}'),
    ('gid://shopify/Customer/2043xxxxx1',
     '{"debitAmount":{"amount":"302.00","currencyCode":"GBP"}}'),
    ('gid://shopify/Customer/2043xxxxx2',
     '{"debitAmount":{"amount":"400.50","currencyCode":"GBP"}}');

-- ---------------------------------------------------------------------
-- 3. Using Companylocation IDs
-- ---------------------------------------------------------------------
CREATE OR REPLACE TABLE SHOPIFY_STORE_CREDIT_ACCOUNT_DEBIT_COMPANYLOCATION_GID (
    id          VARCHAR NOT NULL,
    debitinput  VARCHAR NOT NULL
);

INSERT INTO SHOPIFY_STORE_CREDIT_ACCOUNT_DEBIT_COMPANYLOCATION_GID (id, debitinput)
VALUES
    ('gid://shopify/CompanyLocation/1043xxxxx0',
     '{"debitAmount":{"amount":"1.00","currencyCode":"GBP"}}'),
    ('gid://shopify/CompanyLocation/1043xxxxx1',
     '{"debitAmount":{"amount":"1.50","currencyCode":"GBP"}}');

Limitations

📘

Behaviour of exporter (and additional table for logging)

Whenever you run these reports the connector will store the requests in a table in the same schema with the same name as the destination table + _responses

so if you export little_pond.big_fish, it’ll be little_pond.big_fish_responses

The rows will contain the first level of the request map flattened (like url, method, headers, etc) as columns, and then a response and error columns with the response or error that came from that request.

In subsequent runs, the new rows will be appended to that same table.

🚧

Data Size and Extract Limits

  • You can run up to five bulk mutation operations at a time per shop.
  • Each export is restricted to a maximum of 100 MB. Exceeding either of these thresholds may cause the export to fail. For a complete list of constraints, please refer to the Shopify Bulk Operations documentation.

Updated 2 days ago

Did this page help you?