CONTENT
- Overview
- Example of use
- Setup Screen
- Taxes
- Type Inflow an Outflow
- Taxes
- Test Screen
- Tables
01. OVERVIEW
Totvs developed an integration with Shopify to assist those clients who have the need to integrate Protheus with their marketplace in order to achieve a higher sales demand. The integration was developed in March-July of 2020, and its first version was released on _________. Based on the APIs offered by Shopify, Totvs developed integration with each type of register to attend both Shopify and Protheus required data. The objective of the integration is to concentrate all sales, online and in-store, in Protheus, allowing the client to control its orders, invoices, inventory, finances and accounting in real-time.
Equivalence Overview
- Product Group (SBM): Equivalent to Collections on Shopify.
- Product (SB1 & SB4): Equivalent to Products and their variants in Shopify.
- Customer (SA1): Equivalent to Customer in Shopify.
- Inventory (SB2): Equivalent to Inventory Level in Shopify.
- Orders & Invoice (SC5, SC6, SF2, SD2): Equivalent to Order in Shopify.
For more information on Shopify APIs, please visit: https://shopify.dev/docs/admin-api/rest/reference
Business Rules Definitions
All product register and product groups are primarily added and maintained in Protheus. Products that should be part of Shopify should be added to the table A1K. The final customer goes to the website to purchase products. He adds products to his cart and once he is ready to check out, he needs to either login or register in Shopify, which is validated through table A1D to check if the customer is existing in Protheus or not. If the customer does not exist in Protheus, it is added. The customer finalizes his purchase through paying in the website. The orders are integrated in Protheus, generating a Sales Order, which is released and invoiced automatically. If Protheus does not have enough products to issue that order, it goes to the Error Log Table. If it issues the order/invoice successfully, it generates an Accounts Payable to the customer, which is automatically posted. Workflow is shown below.
02. EXAMPLE OF USE
ChekList for Configuration
Initial Settings
- Updated RPO;
- Updated Invoice Menu;
- It is essential to configure Appserver and DBAccess, to support messages up to 30MB.
The absence of this configuration can generate the error " String size overflow" for messages with many items.
Appserver.ini file:
Please include the keys below:
[Environment]
TopMemoMega =30
[General]
MaxStringSize = 30
- In Invoice (SIGAFAT) access Updates / Miscellaneous / ShopiFy / Paremeters (SHPINT003). Setup the integration information.
- In Invoice (SIGAFAT) access Updates / Registers / Variable Taxes (MATA995).
Add / change the Taxes with the necessary information. See at section 03. Setup Screen a) Taxes
In the “Out f. Formula” and “Inf. Formula” fields, fill in "EUATAX".
- In Invoice (SIGAFAT) access Updates / Registers / Type Inflow an Outflow (MATA080).
Add / change the TES setup ShopiFy Parameters with the necessary information below. See at section 03. Setup Screen b) Type Inflow an Outflow
Use the Variable Taxes created.
Project’s Specific Case Tests
- Collection Registration:
The registration of Collection is carried out in the Protheus system, and will be integrated with the ShopiFy system through ShopiFy API, if you want to check the fields that make up the Collect message, just access: https://shopify.dev/docs/admin-api/rest/reference/products/customcollection?api[version]=2020-04
1. In Invoice (SIGAFAT) access Updates / Registers / Product Groups (MATA035).
Add / change the Product Group with the necessary information. See at section 04. Test Screen 4.1
1.1 Viewing the Collect in ShopiFy:
In the Manager access Products / Collections. See at section 04. Test Screen 4.1.1
- Product Registration:
2.0 In Invoice (SIGAFAT) access Updates / Registers / Product (MATA010).
Add / change the product with the necessary information. See at section 04. Test Screen 4.2.
- Product Grids Registration:
3.0 In Invoice (SIGAFAT) access Updates / Registers / Product Grids (MATA550)
Add / change the product grid with the necessary information. See at section 04. Test Screen 4.3
3.1 Viewing the Products created:
Invoice (SIGAFAT) access Updates / Registers / Product (MATA010). See at section 04. Test Screen 4.3.1
- Product Setup - Registration (ShopiFy Integration):
The registration of Products is carried out in the Protheus system, and will be integrated with the ShopiFy system through ShopiFy API, if you want to check the fields that make up the Product API, just access: https://shopify.dev/docs/admin-api/rest/reference/products/product?api[version]=2020-04
4.0 In Invoice (SIGAFAT) access Updates / Miscellaneous / ShopiFy / Product Setup (SHPINT009)
Add / change the product setup with the necessary information. See section 04. Test Screen 4.4.
4.1 Click Others Actions / Integrate to Integrate with ShopiFy. See section 04. Test Screen 4.4.1
4.2 Viewing the Collect in ShopiFy: In the Manager access Products / All Products. See section 04. Test Screen 4.4.2
- Product Grid Setup - Registration (ShopiFy Integration):
The registration of Product Grids is carried out in the Protheus system, and will be integrated with the ShopiFy system through ShopiFy API, if you want to check the fields that make up the Product Variant API, just access: https://shopify.dev/docs/admin-api/rest/reference/products/product-variant?api[version]=2020-04
5.0 In Invoice (SIGAFAT) access Updates / Miscellaneous / ShopiFy / Product Grid Setup (SHPINT008)
Add / change the Product Grid setup with the necessary information. See at section 04. Test Screen 4.5.0
5.1 Click Others Actions / Integrate to Integrate with ShopiFy. See at section 04. Test Screen 4.5.1
5. 2 Viewing the Collect in ShopiFy. In the Manager Access Products/All Products See at section 04. Test Screen 4.5.2
- Price List / Inventory Registration:
The registration of Prince List is carried out in the Protheus system, and will be integrated with the ShopiFy system through ShopiFy API, if you want to check the fields that make up the Product and Variant API, just access: https://shopify.dev/docs/admin-api/rest/reference/products/product?api[version]=2020-04 / https://shopify.dev/docs/admin-api/rest/reference/products/product-variant?api[version]=2020-04
With each product integration, both the price list and stock level will be updated.
6.0 In Invoice (SIGAFAT) access Updates / Registers / Sales Scenarios / Price Lists (OMSA010)
Add / change the Price List with the necessary information. See at section 04. Test Screen 4.6.
6.1 Viewing the Price List in ShopiFy. In the Manager access Products / All Products. See at section 04. Test Screen 4.6.1
6.2 Viewing the Inventory in ShopiFy. In the Manager access Products / All Products. See at section 04. Test Screen 4.6.2
The registration of inventory item is carried out in the Protheus system , and will be integrated with the ShopiFy system through ShopiFy API, if you want to check the fields that make up the Inventory Level API, just access: https://shopify.dev/docs/admin-api/rest/reference/inventory/inventorylevel?api[version]=2020-04
- Get Order
7.0 Access the store and make a Order. See at section 04. Test Screen 4.7
7.1 Get and View the Sales Order in Protheus. See at section 04. Test Screen 4.7.1
In Invoice (SIGAFAT) access Updates / Miscellaneous / ShopiFy / Invoice Integration (SHPINT001).
In Invoice (SIGAFAT) access Orders /Sales Ordder (MATA410)
- Screen Monitor
8.0 In Invoice (SIGAFAT) access Updates / Miscellaneous / ShopiFy / Monitor Integration (SHPINT005). See at section 04. Test Screen 4.8
Integration log errors will be displayed. You can view or reprocess the item again after correcting the problem.
03. SETUP SCREEN
a) Taxes
b) Type Inflow an Outflow
04. TEST SCREEN
4.1 Product Groups
4.1.1 Collect in ShopiFy
4.2 Product
4.3 Product Grids
4.3.1 Viewing the Products created
4.4 Product Setup - Registrarion (ShopiFy Integration)
4.4.1 ShopiFy Integration
4.4.2 Viewing the Collect in ShopiFy
4.5 Product Grid Setup - Registration (ShopiFy Integration):
4.5.1 Click Others Actions / Integrate to Integrate with ShopiFy
4.5.2 Viewing the Collect in ShopiFy
4.6 Price List / Inventory Registration
4.6.1 Price List in ShopiFy
4.6.2 Inventory in ShopiFy
4.7 Make a Order
4.7.1 Sales Order
4.8 Monitor Integration
05. Tables
- Shopify Integration Error Log (A1C) – Stores integration error logs for further analysis and correction.
- Shopify Identifiers (A1D) – Stores the “from-to” equivalence between Protheus & Shopify.
- Shopify Product Images (A1E) – Stores images URLs for Shopify exhibition.
- Shopify Integration Parameters (A1F) – Stores integration parameters such as endpoints, API version, integration activation status, etc.
- Shopify Integration Products (A1K) – Stores which products from Protheus should be exhibited in Shopify.
- Shopify Tax Order Details (A1L) – Stores taxes details of each order
- Shopify Product Grid Set-up (A1M) – Defines how product grids are exhibited in Shopify.
Data Dictionary
Table: A1C – Shopify Integration Error Log
Index | Key |
01 | A1C_FILIAL+A1C_INTEGR |
02 | A1C_FILIAL+A1C_DATE+A1C_TIME |
Field | A1C_FILIAL |
Type | C |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch of the System |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | No |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1C_INTEGR |
Type | C |
Size | 50 |
Decimal | 0 |
Format | @! |
Title | Int. Code |
Description | Integration code |
Level | 0 |
Used | Yes |
Required | 0 |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Integration code |
Field | A1C_ID |
Type | C |
Size | 50 |
Decimal | 0 |
Format | |
Title | Id |
Description | Identifier |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Alias Identifier |
Field | A1C_IDEXT |
Type | C |
Size | 50 |
Decimal | 0 |
Format | |
Title | External Id |
Description | External Id |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | External Id |
Field | A1C_MESSAG |
Type | M |
Size | 10 |
Decimal | 0 |
Format | |
Title | Message |
Description | Log Message |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Log Message |
Field | A1C_PATH |
Type | C |
Size | 254 |
Decimal | 0 |
Format | |
Title | Api Path |
Description | Api Path |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Api Path |
Field | A1C_APIVER |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | Api Version |
Description | Api Version |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Api Version |
Field | A1C_BODY |
Type | M |
Size | 10 |
Decimal | 0 |
Format | |
Title | Request Body |
Description | Request Body |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Request Body |
Field | A1C_VERB |
Type | C |
Size | 10 |
Decimal | 0 |
Format | |
Title | Request Verb |
Description | Request Verb |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Request Verb |
Field | A1C_DATE |
Type | D |
Size | 8 |
Decimal | 0 |
Format | |
Title | Date |
Description | Log date |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Log date |
Field | A1C_TIME |
Type | C |
Size | 8 |
Decimal | 0 |
Format | 99:99:99 |
Title | Time |
Description | Log time |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Log time |
Field | A1C_STATUS |
Type | C |
Size | 1 |
Decimal | 0 |
Format | |
Title | Status |
Description | Error Status |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | P=Pendente;R=Resolvido |
When | |
Relationship | "P" |
Val. System | |
Val. User | |
F3 | |
Help | Error Status |
Table: A1D – Shopify Identifiers
Index | Key |
01 | A1D_FILIAL+A1D_ALIAS+A1D_ID |
02 | A1D_FILIAL+A1D_ALIAS+A1D_ID+A1D_IDEXT+A1D_ALIASP+A1D_IDPAI |
Field | A1D_FILIAL |
Type | C |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch of the System |
Level | 1 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1D_ALIAS |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | Alias |
Description | Alias |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Alias |
Field | A1D_ID |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | Protheus Id |
Description | Protheus Id |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Protheus Id |
Field | A1D_IDEXT |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | External Id |
Description | External Id |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | External Id |
Field | A1D_ALIASP |
Type | C |
Size | 50 |
Decimal | 0 |
Format | |
Title | Main Alias |
Description | Main Alias |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Main Alias |
Field | A1D_IDPAI |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | Main Id |
Description | Main Id |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Main Id |
Field | A1D_LASTUP |
Type | C |
Size | 30 |
Decimal | 0 |
Format | |
Title | Last Update |
Description | Last Update |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Last Update |
Table: A1E – Shopify Product Images
Index | Key |
01 | A1E_FILIAL+A1E_COD |
02 | A1E_FILIAL+A1E_COD+A1E_SEQUEN |
Field | A1E_FILIAL |
Type | C |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch of the System |
Level | 1 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1E_COD |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | Product Code |
Description | Product Code |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | SB1 |
Help | Product Code |
Field | A1E_SEQUEN |
Type | C |
Size | 3 |
Decimal | 0 |
Format | |
Title | Sequence |
Description | Image sequence |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Image sequence |
Field | A1E_DESC |
Type | C |
Size | 30 |
Decimal | 0 |
Format | |
Title | Description |
Description | Description |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Description |
Field | A1E_URL |
Type | C |
Size | 254 |
Decimal | 0 |
Format | |
Title | Photo Url |
Description | Photo url |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Photo url |
Field | A1E_INTEGR |
Type | C |
Size | 1 |
Decimal | 0 |
Format | |
Title | Int.Shopify? |
Description | Integrate with Shopify |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | 1=Sim;2=Não |
When | |
Relationship | '2' |
Val. System | |
Val. User | |
F3 | |
Help |
Table: A1F – Shopify integration parameters
Index | Key |
01 | A1F_FILIAL+A1F_PARAM |
Field | A1F_FILIAL |
Type | C |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch of the System |
Level | 1 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1F_PARAM |
Type | C |
Size | 20 |
Decimal | 0 |
Format | @! |
Title | Parameter |
Description | Parameter name |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | ExistChav("A1F", M->A1F_PARAM, 1) |
F3 | |
Help | Parameter name |
Field | A1F_DESC |
Type | C |
Size | 254 |
Decimal | 0 |
Format | @! |
Title | Description |
Description | Parameter description |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Parameter description |
Field | A1F_CONT |
Type | C |
Size | 254 |
Decimal | 0 |
Format | |
Title | Content |
Description | Parameter content |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Parameter content |
Field | A1F_MANDAT |
Type | C |
Size | 1 |
Decimal | 0 |
Format | |
Title | Mandatory |
Description | Mandatory parameter |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | 1=Sim;2=Não |
When | |
Relationship | "1" |
Val. System | |
Val. User | |
F3 | |
Help | Mandatory parameter |
Table: A1K – Shopify integration products
Index | Key |
01 | A1K_FILIAL+A1K_COD |
02 | A1K_FILIAL+A1K_CODPAI |
Field | A1K_FILIAL |
Type | C |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch of the System |
Level | 1 |
Used | Yes |
Required | 0 |
Browse | N |
Options | |
When | |
Relationship | xFilial("A1K") |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1K_SEQUEN |
Type | C |
Size | 3 |
Decimal | 0 |
Format | |
Title | Sequence |
Description | Display sequence |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Display sequence |
Field | A1K_COD |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | Product Code |
Description | Product code |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | ExistCpo("SB1", M->A1K_COD) |
F3 | SB1 |
Help | Product code |
Field | A1K_DESC |
Type | C |
Size | 70 |
Decimal | 0 |
Format | |
Title | Description |
Description | Product description |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | IF(INCLUI,"",GETADVFVAL("SB1","B1_DESC", XFILIAL("SB1") + A1K->A1K_COD,1)) |
Val. System | |
Val. User | |
F3 | |
Help | Product description |
Field | A1K_TAX |
Type | C |
Size | 1 |
Decimal | 0 |
Format | |
Title | Taxable? |
Description | Taxable Product? |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | 1=Sim;2=Não |
When | |
Relationship | '1' |
Val. System | |
Val. User | |
F3 | |
Help | Taxable Product? |
Field | A1K_INI |
Type | D |
Size | 8 |
Decimal | 0 |
Format | |
Title | Initial date |
Description | Initial date |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | Date() |
Val. System | |
Val. User | |
F3 | |
Help | Initial date |
Field | A1K_FIM |
Type | D |
Size | 8 |
Decimal | 0 |
Format | |
Title | End Date |
Description | End Date |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | End Date |
Field | A1K_GRIDID |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | Grid Id |
Description | Grid Id |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | ExistCpo("ZZY", M->A1K_GRIDID) |
F3 | |
Help | Grid Id |
Field | A1K_SQLTIT |
Type | C |
Size | 100 |
Decimal | 0 |
Format | |
Title | Sql - Title |
Description | Sql Field for title |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | SQL Field for brand. Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV) |
Field | A1K_SQLPES |
Type | C |
Size | 100 |
Decimal | 0 |
Format | |
Title | Sql - Weight |
Description | Sql field for Weight |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Sql field for Weight.Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV) |
Field | A1K_CODPAI |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | Parent Code |
Description | Parent Code |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Parent Code |
Table: A1L – Shopify Tax
Index | Key |
01 | A1L_FILIAL+ A1L_ORDER |
02 | A1L_FILIAL+ A1L_TAXCOD |
Field | A1L_FILIAL |
Type | C |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch of the System |
Level | 1 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_ID |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | ID |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_SKU |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | SKU |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_ITEM |
Type | C |
Size | 2 |
Decimal | 0 |
Format | |
Title | Item |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_ORDER |
Type | C |
Size | 10 |
Decimal | 0 |
Format | |
Title | Order |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_VALIMP |
Type | N |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | Sales Tax |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_BASIMP |
Type | N |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | Tax Rate |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_TAXCOD |
Type | C |
Size | 30 |
Decimal | 0 |
Format | |
Title | Tax Code |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_ALIIMP |
Type | N |
Size | 6 |
Decimal | 2 |
Format | @E 999.99 |
Title | Tax Rate |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_INVOIC |
Type | C |
Size | 13 |
Decimal | 0 |
Format | |
Title | Invoice Numb |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_SERIE |
Type | C |
Size | 3 |
Decimal | 0 |
Format | |
Title | Serie |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_CLIENT |
Type | C |
Size | 6 |
Decimal | 0 |
Format | |
Title | Client |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1L_LOJA |
Type | C |
Size | 4 |
Decimal | 0 |
Format | |
Title | Store |
Description | |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Table: A1M – Shopify Product Setup
Index | Key |
01 | A1M_FILIAL+ A1M_COD |
Field | A1M_FILIAL |
Type | C |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch of the System |
Level | 1 |
Used | Yes |
Required | 0 |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1M_COD |
Type | C |
Size | 20 |
Decimal | 0 |
Format | |
Title | Shopify Prod |
Description | Shopify Prod |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | INCLUI |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Shopify Product |
Field | A1M_DESC |
Type | C |
Size | 254 |
Decimal | 0 |
Format | @! |
Title | Description |
Description | Grid description |
Level | 0 |
Used | Yes |
Required | No |
Browse | S |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Grid description |
Field | A1M_SQLTIT |
Type | C |
Size | 100 |
Decimal | 0 |
Format | |
Title | Sql - Title |
Description | SQL Field for title |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | SQL Field for title. Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV) |
Field | A1M_SQLMAR |
Type | C |
Size | 100 |
Decimal | 0 |
Format | |
Title | Sql - Brand |
Description | SQL Field for brand |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | SQL Field for brand. Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV) |
Field | A1M_SQLHTM |
Type | C |
Size | 254 |
Decimal | 0 |
Format | |
Title | Sql - Html |
Description | Sql - Body Html |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Sql - Body Html.Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV) |
Field | A1M_SQLTP |
Type | C |
Size | 100 |
Decimal | 0 |
Format | |
Title | Sql-Prod Tp |
Description | SQL Field for prod. type |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help |
Field | A1M_SQLTAG |
Type | C |
Size | 254 |
Decimal | 0 |
Format | |
Title | Sql - Tag |
Description | SQL field for tag |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | SQL field for tag.The content must be separated by comma.Available table alias: SB1, SBM, SB4, SB5, LIN (SBV), COL (SBV) |
Field | A1M_GRADE |
Type | C |
Size | 1 |
Decimal | 0 |
Format | |
Title | Grid? |
Description | Product Grid? |
Level | 0 |
Used | Yes |
Required | No |
Browse | N |
Options | 1=Sim;2=Não |
When | |
Relationship | |
Val. System | |
Val. User | |
F3 | |
Help | Product Grid? |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas