E-Commerce

Convert Shopify orders to sales invoices automatically

39 nodes 289 140 Scheduled trigger
Download

Workflow Description

A scheduled automation that extracts Shopify orders periodically and transforms them into organized sales documents and invoices, processing data in batches with intelligent filtering based on specific criteria to streamline accounting operations.

How it works

  1. 1.Retrieve orders from Shopify on a defined schedule
  2. 2.Divide data into batches for efficient processing
  3. 3.Apply conditions to filter orders eligible for conversion
  4. 4.Transform order data into sales invoice structure
  5. 5.Generate final records in your sales system

Use cases

  • Automate daily invoice creation from store orders without manual intervention
  • Process thousands of orders efficiently and consistently
  • Synchronize sales data between Shopify and accounting systems seamlessly

Requirements

  • Active Shopify account with API access to order data
  • Knowledge of custom data patterns required in your invoice system
  • Configured schedule timing aligned with your order processing workflow

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

If Split In Batches

Details

Trigger Scheduled trigger
Nodes 39
Apps 2
Views 289
Downloads 140

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (39)

/

GetFufillmentOrders

HTTP Request

#1

Sticky Note3

Sticky Note

#2

Sticky Note6

Sticky Note

#3

Sticky Note8

Sticky Note

#4

Sticky Note12

Sticky Note

#5

Shopify

If

#6

Sticky Note

Sticky Note

#7

Sticky Note10

Sticky Note

#8

Sticky Note11

Sticky Note

#9

Schedule Trigger

Schedule Trigger

#10

Loop Over Items

Split In Batches

#11

New Customer?

If

#12

Lookup Customers

HTTP Request

#13

SelectFields

Set

#14

orderPreprocessing

Code

#15

Create Customer

HTTP Request

#16

Set Business Central Customer Id

Set

#17

Create Order Lines

HTTP Request

#18

End

No Op

#19

Split Out

Split Out

#20

DELETE Sales Order

HTTP Request

#21

D365 BC Environment Settings

Set

#22

Create Sales Order

HTTP Request

#23

Sticky Note13

Sticky Note

#24

Set Lines Invoice

Set

#25

Set Lines SO

Set

#26

Split Out Invoice

Split Out

#27

Create Invoice Lines

HTTP Request

#28

Filter

Filter

#29

Create Sales Invoice

HTTP Request

#30

End1

No Op

#31

Sales Invoice

Set

#32

Lookup Sales Order

HTTP Request

#33

Sales Order Mapping

Set

#34

New SO?

If

#35

Lookup Sales Invoice

HTTP Request

#36

New Invoice?

If

#37

POS?

If

#38

DELETE Sales Invoice

HTTP Request

#39