Connectors
Cin7
Connectors
Cin7
Description
Cin7 is an all-in-one, cloud-based solution with fully integrated inventory management, POS, EDI and 3PL functions in a single system.
Connector Details
| Name | Value |
|---|---|
| Platform | Cin7 |
| Auth Type | API Keys |
| Direction | Bidirectional |
Supported Data
See the table below for the list of data you can read with the Cin7 connector.
| Table Name | Fields |
|---|---|
| branches | id, branchType, stockControlOptions, taxStatus, accountNumber, branchLocations, createdDate, modifiedDate, isActive, company, firstName, lastName, jobTitle, email, website, phone, fax, mobile, address1, address2, city, state, postCode, country, postalAddress1, postalAddress2, postalCity, postalPostCode, postalState, postalCountry, notes, integrationRef, customFields, secondaryContacts |
| contact_supplier | id, createdDate, modifiedDate, isActive, type, company, firstName, lastName, jobTitle, email, website, phone, fax, mobile, address1, address2, city, state, postCode, country, postalAddress1, postalAddress2, postalCity, postalPostCode, postalState, postalCountry, notes, integrationRef, salesPersonId, accountNumber, billingId, billingCompany, accountsFirstName, accountsLastName, billingEmail, accountsPhone, billingCostCenter, priceColumn, creditLimit, balanceOwing |
| products | id, name, status, createdDate, modifiedDate, description, images, supplierId, brand, category, stockControl, orderType, productType, productOptions |
| purchase_orders | id, createdDate, modifiedDate, createdBy, processedBy, isApproved, reference, memberId, firstName, lastName, company, email, phone, mobile, fax, deliveryFirstName, deliveryLastName, deliveryCompany, deliveryAddress1, deliveryAddress2, deliveryCity, deliveryState, deliveryPostalCode, deliveryCountry, billingFirstName, billingLastName, billingCompany, billingAddress1, billingAddress2, billingCity, billingPostalCode, billingState, billingCountry, branchId, branchEmail, projectName, trackingCode, internalComments, productTotal, freightTotal, freightDescription, surcharge, surchargeDescription, discountTotal, discountDescription, total, currencyCode, currencyRate, currencySymbol, taxStatus, taxRate, source, isVoid, memberEmail, memberCostCenter, memberAlternativeTaxRate, costCenter, alternativeTaxRate, estimatedDeliveryDate, salesPersonId, salesPersonEmail, paymentTerms, customerOrderNo, voucherCode, deliveryInstructions, status, stage, supplierInvoiceReference, supplierAcceptanceDate, fullyReceivedDate, invoiceDate, lineItems |
| sale_order | id, createdDate, modifiedDate, createdBy, processedBy, isApproved, reference, memberId, firstName, lastName, company, email, phone, mobile, fax, deliveryFirstName, deliveryLastName, deliveryCompany, deliveryAddress1, deliveryAddress2, deliveryCity, deliveryState, deliveryPostalCode, deliveryCountry, billingFirstName, billingLastName, billingCompany, billingAddress1, billingAddress2, billingCity, billingPostalCode, billingState, billingCountry, branchId, branchEmail, projectName, trackingCode, internalComments, productTotal, freightTotal, freightDescription, surcharge, surchargeDescription, discountTotal, discountDescription, total, currencyCode, currencyRate, currencySymbol, taxStatus, taxRate, source, isVoid, memberEmail, memberCostCenter, memberAlternativeTaxRate, costCenter, alternativeTaxRate, estimatedDeliveryDate, salesPersonId, salesPersonEmail, paymentTerms, customerOrderNo, voucherCode, deliveryInstructions, status, stage, invoiceDate, invoiceNumber, dispatchedDate, logisticsCarrier, logisticsStatus, distributionBranchId, lineItems |
| stockstream | productId, productOptionId, modifiedDate, styleCode, code, barcode, branchId, branchName, productName, option1, option2, option3, size, available, stockOnHand, openSales, incoming, virtual, holding |
| voucher | customerID, createdDate, status, code, type, description, expiryDate, amount, customerEmail, redeemedCount, redeemedCountLimit, redeemedAmount |