Connecting to Printful

Printful uses token authentication to control access to the API.

Using Token Authentication

In order to authenticate to Printful, you'll need to provide your API Key. To get your API Key, first go to 'Settings' then 'Stores'. Select the Store you would like to connect to, then click the 'Add API Access' button to generate an API Key. Set the API Key in the ProfileSettings property to connect.

Example connection string

Profile=C:\profiles\Printful.apip;ProfileSettings='APIKey=my_api_key';

Working with Multiple Stores

If your Printful account manages more than one store, such as when you are using an account-level access token, set the StoreId connection property to the numeric ID of the store you want to query or modify data for. The driver sends this value using the X-PF-Store-Id request header. If StoreId is left unset, Printful applies the account's default authorized store.

You can find a store's numeric ID in the Stores section of your Printful account dashboard, or in the Id column returned by the Store table.

Example connection string

Profile=C:\profiles\Printful.apip;ProfileSettings='APIKey=my_api_key;StoreId=1234567';

Available Tables

The Printful API Profile provides access to the following tables:

CountriesCodes: Returns a list of countries and states accepted by Printful.
Files: Retrieve details of a single file (requires Id).
OrderItems: Returns the items for a given order (requires OrderId).
Orders: Returns the orders in your store.
PrintfulProducts: Returns the catalog of products available in Printful.
PrintfulProductVariants: Returns the variants for a specific catalog product (requires ProductId or Id).
ProductLayoutTemplates: Returns the layout templates available for client-side positioning on a product (requires ProductId).
ProductVariantPrintfiles: Returns the printfiles available for a product's variants (requires ProductId).
Store: Returns information about the currently authorized Printful store.
StoreProducts: Returns the sync products in your custom Printful store.
StoreProductVariants: Returns the variants for a specific sync product (requires ProductId or Id).
SyncProducts: Returns the sync products in your store.
SyncProductVariants: Returns the variants for a specific sync product (requires ProductId or Id).
WarehouseProducts: Returns the warehouse products in your store.
WarehouseShipments: Returns the warehouse shipments in your store.
Webhooks: Returns the configured webhook URL and the webhook event types enabled for the store.

Example Queries

CountriesCodes:

SELECT * FROM CountriesCodes

Store:

SELECT * FROM Store

Orders:

SELECT * FROM Orders

OrderItems:

SELECT * FROM OrderItems WHERE OrderId = 12345678

Files:

SELECT * FROM Files WHERE Id = 12345678

PrintfulProducts:

SELECT * FROM PrintfulProducts

PrintfulProductVariants:

SELECT * FROM PrintfulProductVariants WHERE ProductId = 71

ProductLayoutTemplates:

SELECT * FROM ProductLayoutTemplates WHERE ProductId = 71

ProductVariantPrintfiles:

SELECT * FROM ProductVariantPrintfiles WHERE ProductId = 71

StoreProducts:

SELECT * FROM StoreProducts

StoreProductVariants:

SELECT * FROM StoreProductVariants WHERE ProductId = 12345678

SyncProducts:

SELECT * FROM SyncProducts

SyncProductVariants:

SELECT * FROM SyncProductVariants WHERE ProductId = 12345678

WarehouseProducts:

SELECT * FROM WarehouseProducts

WarehouseShipments:

SELECT * FROM WarehouseShipments

Webhooks:

SELECT * FROM Webhooks

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

Property	Description
APIKey	Your store API Key in Printful account.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT, OAUTH_PASSWORD
StoreId	The numeric ID of the Printful store that requests are scoped to, sent using the X-PF-Store-Id request header.