Connectors
Picqer
Connectors
Picqer
Description
Warehouse Management Software for Webshops
Connector Details
| Name | Value |
|---|---|
| Platform | Picqer |
| Auth Type | API Keys |
| Direction | Read |
Supported Data
See the table below for the list of data you can read with the Picqer connector.
| Table Name | Fields |
|---|---|
| backorders | idbackorder, idorder, idproduct, idcustomer, idwarehouse, amount, amount_available, priority, created_at, date_available |
| image_products | idproduct, idproduct_image, url, contenttype, size |
| location_products | idlocation, idwarehouse, parent_idlocation, name, unlink_on_empty, location_type, is_bulk_location, stock_for_product |
| orderfields | idorderfield, title, type, required, visible_picklist, visible_portal |
| orders | idorder, idcustomer, idtemplate, idshippingprovider_profile, orderid, deliveryname, deliverycontactname, deliveryaddress, deliveryaddress2, deliveryzipcode, deliverycity, deliveryregion, deliverycountry, full_delivery_address, invoicename, invoicecontactname, invoiceaddress, invoiceaddress2, invoicezipcode, invoicecity, invoiceregion, invoicecountry, full_invoice_address, telephone, emailaddress, reference, customer_remarks, partialdelivery, discount, invoiced, status, idfulfilment_customer, warehouses, preferred_delivery_date, language, products, pricelists, picklists, created |
| part_products | idproduct_part, idproduct, amount, productcode, name |
| productfields | idproductfield, title, type, required, visible_picklist, visible_invoice, visible_shippinglist, visible_portal, visible_purchase_order |
| products | idproduct, idvatgroup, name, price, fixedstockprice, idsupplier, productcode, productcode_supplier, deliverytime, description, barcode, type, unlimitedstock, weight, length, width, height, minimum_purchase_quantity, purchase_in_quantities_of, hs_code, country_of_origin, active, idfulfilment_customer, analysis_pick_amount_per_day, pricelists |
| purchaseorders | idpurchaseorder, idsupplier, idtemplate, idwarehouse, purchaseorderid, supplier_name, supplier_orderid, updated, status, remarks, delivery_date, language, products, idfulfilment_customer |
| suppliers | idsupplier, name, contactname, address, address2, zipcode, city, region, country, telephone, emailaddress, remarks, language |
| warehouse_products | idproduct, idwarehouse, stock_level_order, stock_level_desired, stock_level_maximum, stock_location |
| warehouses | idwarehouse, name, accept_orders, counts_for_general_stock, priority, active |