Linnworks

Tables in the Linnworks connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	stock_location_details	15	StockLocationIntId	Full Refresh
2	processed_order_details	15	NumOrderId	Full Refresh, Incremental	ProcessedDateTime
3	processed_orders	62	nOrderId	Full Refresh, Incremental	dProcessedOn
4	stock_locations	7	StockLocationIntId	Full Refresh
5	stock_items	31	StockItemIntId	Full Refresh

Table: stock_location_details

No	Column Name	Type	Notes
1	ZipCode	VARCHAR
2	Address2	VARCHAR
3	IsWarehouseManaged	BOOLEAN
4	Address1	VARCHAR
5	City	VARCHAR
6	County	VARCHAR
7	LocationName	VARCHAR
8	IsFulfillmentCenter	BOOLEAN
9	LocationTag	VARCHAR
10	StockLocationId	VARCHAR
11	Country	VARCHAR
12	CountInOrderUntilAcknowledgement	BOOLEAN
13	StockLocationIntId	INTEGER	Primary Key
14	FulfilmentCenterDeductStockWhenProcessed	BOOLEAN
15	IsNotTrackable	BOOLEAN

Table: processed_order_details

No	Column Name	Type	Notes
1	TaxId	VARCHAR
2	OrderId	VARCHAR
3	FolderName	VARCHAR
4	ExtendedProperties	VARCHAR
5	NumOrderId	INTEGER	Primary Key
6	GeneralInfo	VARCHAR
7	TotalsInfo	VARCHAR
8	FulfilmentLocationId	VARCHAR
9	ShippingInfo	VARCHAR
10	Items	VARCHAR
11	CustomerInfo	VARCHAR
12	PaidDateTime	VARCHAR
13	ProcessedDateTime	VARCHAR	Incremental sync key
14	Notes	VARCHAR
15	Processed	BOOLEAN

Table: processed_orders

No	Column Name	Type	Notes
1	Company	VARCHAR
2	PostalServiceName	VARCHAR
3	HoldOrCancel	BOOLEAN
4	CountryTaxRate	DOUBLE
5	fTotalCharge	DOUBLE
6	cCurrency	VARCHAR
7	fPostageCost	DOUBLE
8	ReferenceNum	VARCHAR
9	ItemWeight	DOUBLE
10	BillingRegion	VARCHAR
11	BillingPhoneNumber	VARCHAR
12	ExternalReference	VARCHAR
13	Town	VARCHAR
14	BuyerPhoneNumber	VARCHAR
15	cShippingAddress	VARCHAR
16	cFullName	VARCHAR
17	PackageTitle	VARCHAR
18	cEmailAddress	VARCHAR
19	dReceivedDate	VARCHAR
20	cBillingAddress	VARCHAR
21	nStatus	INTEGER
22	FulfilmentLocationName	VARCHAR
23	ProfitMargin	DOUBLE
24	PostalTrackingNumber	VARCHAR
25	Subtotal	DOUBLE
26	dProcessedOn	VARCHAR	Incremental sync key
27	IsExchange	BOOLEAN
28	TotalWeight	DOUBLE
29	dPaidOn	VARCHAR
30	Region	VARCHAR
31	PostalServiceCode	VARCHAR
32	pkOrderID	VARCHAR
33	nOrderId	INTEGER	Primary Key
34	AccountName	VARCHAR
35	BillingPostCode	VARCHAR
36	fTax	DOUBLE
37	TaxId	VARCHAR
38	Source	VARCHAR
39	PackageCategory	VARCHAR
40	timeDiff	DOUBLE
41	SecondaryReference	VARCHAR
42	cCountry	VARCHAR
43	PostageCostExTax	DOUBLE
44	cPostCode	VARCHAR
45	BillingEmailAddress	VARCHAR
46	dCancelledOn	VARCHAR
47	BillingName	VARCHAR
48	BillingCountryName	VARCHAR
49	BillingAddress1	VARCHAR
50	BillingTown	VARCHAR
51	BillingAddress2	VARCHAR
52	BillingAddress3	VARCHAR
53	Address2	VARCHAR
54	Address3	VARCHAR
55	SubSource	VARCHAR
56	Vendor	VARCHAR
57	Address1	VARCHAR
58	ChannelBuyerName	VARCHAR
59	IsResend	BOOLEAN
60	FolderCollection	VARCHAR
61	BillingCompany	VARCHAR
62	TotalDiscount	DOUBLE

Table: stock_locations

No	Column Name	Type	Notes
1	LocationTag	VARCHAR
2	StockLocationId	VARCHAR
3	BinRack	VARCHAR
4	IsWarehouseManaged	BOOLEAN
5	StockLocationIntId	INTEGER	Primary Key
6	LocationName	VARCHAR
7	IsFulfillmentCenter	BOOLEAN

Table: stock_items

No	Column Name	Type	Notes
1	CategoryId	VARCHAR
2	CreationDate	VARCHAR
3	BarcodeNumber	VARCHAR
4	RetailPrice	DOUBLE
5	PostalServiceName	VARCHAR
6	InventoryTrackingType	INTEGER
7	isBatchedStockType	BOOLEAN
8	PurchasePrice	DOUBLE
9	StockItemIntId	INTEGER	Primary Key
10	Depth	DOUBLE
11	SerialNumberScanRequired	BOOLEAN
12	Suppliers	VARCHAR
13	ItemNumber	VARCHAR
14	PackageGroupId	VARCHAR
15	BatchNumberScanRequired	BOOLEAN
16	MetaData	VARCHAR
17	ItemTitle	VARCHAR
18	TaxRate	DOUBLE
19	StockLevels	VARCHAR
20	Height	DOUBLE
21	PostalServiceId	VARCHAR
22	Width	DOUBLE
23	ItemChannelDescriptions	VARCHAR
24	ItemChannelTitles	VARCHAR
25	ItemExtendedProperties	VARCHAR
26	Images	VARCHAR
27	StockItemId	VARCHAR
28	Weight	DOUBLE
29	ItemChannelPrices	VARCHAR
30	CategoryName	VARCHAR
31	PackageGroupName	VARCHAR

External Resources

• Linnworks Api
• Stocklocations
• Stocklocationdetails
• Stockitems
• Processedorders
• Processedorderdetails
• Developer Portal
• Seller Portal

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.