A detailed description about how to generate token and keys for various connectors supported in PCC is provided in the following sections.
Generating Token and API Path to Configure BigCommerce Store
Generating API and Shared Secret Key to Configure Shopify Store
Generating API and Secret key to Configure OroCommerce Store
Generating Token and Keys to Configure Magento Store
To generate the token and keys:
Type the URL of the Magento store and the Magento login page appears as shown below.
Type the Username and Password and click Sign In. The dashboard appears as follows.
In the menu on the left-hand side of the screen, click SYSTEM > Integrations as shown below.
The following screen appears.
A list of integrations already created between PCC and Magento is displayed.
Click Add New Integration and the following dialog box appears.
You need to enter the basic information related to integration.
Enter any unique Name for the integration being created. For example, AM-0420.
Enter Your Password which is currently being used to access Magento.
The remaining details are not mandatory.
Under the Basic Settings menu, click the API tab and the following is displayed.
Select the Resources that will be required while using the store. In this case, click Attributes under Stores as we are fetching Magento attributes from the store to PCC which will be used for attribute mapping as shown below.
Click Save and the integration created is saved and displayed in the list as shown below.
Click Activate in the Activate column for the integration created and the following screen appears.
Based on the selections made while creating the integration, click Allow to provide access to these functions in Magento.
The integration tokens are generated and displayed as follows.
Figure 371: integration tokens
These tokens and keys can now be used to configure the store in PCC.
Importing Mapped Attributes to Magento
Once the attributes are mapped and the data is exported in CSV format, this data needs to be imported to the Magento store.
To import the data to the Magento store:
Log on to the Magento store using your credentials.
In the menu on the left hand side of the screen, click SYSTEM > Import as shown below.
The following screen appears.
In the Import Settings, select the Entity Type as Products from the drop-down list as the attributes mapped for the products are to be imported as shown below.
The following fields are displayed after selecting the entity type.
NOTE | The CSV file being imported should not be more than 2MB which is the current default size limit. |
Click Download Sample File to view the structure of the sample file. The file being imported should have column headings spelled correctly as mentioned in this sample file.
Select the Import Behavior to be one of the following from the drop-down list as shown below.
Select one of the following based on the action to be performed:
Add/Update - This option will add any new attributes being imported for an existing SKU as well as in case of attribute values, an existing attribute value will be overwritten by the new value being passed through the file for the same attribute.
Replace – This option will replace existing attributes for a SKU with the attributes being passed though the file as well as in case of attribute values, an existing attribute value will be replaced by the new value being passed through the file for the same attribute.
Delete - This option will delete the attributes being passed through the file for an existing SKU if a match is found. If no match is found, the existing SKU attributes and its values remain as is.
Select the Validation Strategy to be one of the following from the drop-down list as shown below.
This determines what happens when an error is encountered when importing data.
Enter the Allowed Errors Count, that is, the number of errors that can occur before the import is canceled. The default value is 10.
Enter the Field separator. By default, the value is comma (,). In a CSV file, a comma is used to separate multiple fields present in the file.
Enter the Multiple value separator. By default, the value is comma (,). Here, you need to add the separator as semicolon (;) as it is being used in the file exported from PCC to separate multiple values for an attribute.
Set the Empty attribute value constant as __EMPTY__VALUE__ if you want an attribute value to be blank / empty for an attribute that has a default value. In this case, you must add this value (__EMPTY__VALUE__) for the respective attribute in the file that is being imported. Thus, after the file is imported, the value for those attributes will be blank.
Select Fields Enclosure if you want to enclose any special characters (such as the equal sign, greater and less than symbols, single and double quotes,) that might be found in the data so that the system understands that these characters are used to represent the actual data.
Click Choose File to select the file to be imported. Only CSV files are supported.
Select the CSV file to be imported and then click Open. The file is uploaded.
In the upper-right corner of the screen, click Check Data.
The data is validated and the validation results are displayed as follows.
In case of any error in the file uploaded, as shown above, you need to fix the errors mentioned until there is no validation error in the file.
Click Import once the file validated has no errors and the file is imported successfully.
You can check the details of the attributes imported for a SKU in the Products page. In the menu, click CATALOG > Products. You can search the SKU ID of the product containing attributes which are mapped.
Generating Token and Keys to Configure WooCommerce Store
To generate the token and keys:
Type the URL of the WooCommerce store and the WooCommerce login page appears as shown below.
NOTE | Each customer will have a unique URL for their store as configured in WooCommerce. |
Type the Username and Password and click Log In. The dashboard appears as follows.
In the menu on the left hand side of the screen, hover the mouse on the WooCommerce icon and then click Settings as shown below.
The following screen appears.
Click the Advanced tab and then click REST API as shown below.
A list of integrations already created between PCC and WooCommerce is displayed.
Click Add key to generate the keys and the following is displayed.
Enter any Description for identifying the key being generated.
Select the User who will own the key from the drop-down list.
Select the Permission to be granted for this API key — Read access / Write access / Read/Write access from the drop-down list.
Click Generate API key and the key is generated successfully as shown below.
NOTE | Ensure that you copy the keys as the secret key will be hidden once you leave the page. |
To set up the store configuration in PCC, you need the Consumer Key and Consumer Secret.
Generating Token and API Path to Configure BigCommerce Store
To generate the token and API Path:
Type the URL of the BigCommerce store and the login page appears as shown below.
NOTE | Each customer will have a unique URL for their store as configured in BigCommerce. |
Type the Email ID and Password and click Log In. The dashboard appears as follows.
In the menu on the left hand side of the screen, click Advanced Settings > API Accounts as shown below.
The Store API Accounts page is displayed.
Click Create API Account and then click Create V2 / V3 API Token as shown below.
The Create API Account page is displayed. Since the product data will be exported from PCC to the BigCommerce store, you need to set the necessary access for products.
Select the modify option under Products as shown below.
Type a name for the ERP connection being established as shown below.
Click Save to generate the API credentials to be used in PCC for configuring the store and the following is displayed.
A text file is downloaded automatically with the token and API path details required for configuring the store if you are using Chrome, Firefox or Edge as the browser as shown below.
NOTE | If you lose the credentials generated , you need to delete the account and create a new one as mentioned in the disclaimer. |
To set up the store configuration in PCC, you need the API PATH and ACCESS TOKEN.
Generating API and Shared Secret Key to Configure Shopify Store
To generate the secret and API key:
Type the URL of the Shopify store and the login page appears as shown below.
NOTE | Each customer will have a unique URL for their store as configured in Shopify. |
Type the Email ID and click Next.
Type the Password and click Log In. The dashboard page appears as follows.
In the menu on the left-hand side of the screen, click Apps as shown below.
The Apps page is displayed.
Scroll to the bottom of the page and then click Manage private apps as shown below.
The following page is displayed.
Click Create new private app and the following is displayed.
Type a name for the private app and email ID of the account to which Shopify will send a notification in case of any issue in the private app created such as an API change might affect the connection and so on.
Click Show inactive API permissions to select the areas of the store that the app being created should be able to access. A list of areas is displayed as shown below.
Scroll to the Products section as you will be exporting products from PCC to the Shopify store and select Read and Write access as shown below.
This access is important to ensure that the product data flows seamlessly between PCC and the Shopify store.
Click Save to generate the API credentials and the following dialog box appears.
Click Create app to create the private app which will generate the API key required to access the store’s data as well as to configure the store in PCC.
The API key and password details are added in the Admin API section as shown below.
You can use these credentials to make authenticated requests to the Shopify store that uses your application.
To set up the store configuration in PCC, you need the API Key, Password and Shared Secret.
Generating Client ID and Client Secret Key to Configure OroCommerce Store
To generate the Client ID and Client Secret key:
Type the URL of the OroCommerce store and the following page will open where you will have to type your username and password to log into your account.
Click on the
symbol on the top-right hand corner of the window.
Click on My User from the drop-down list.
On the new window that opens, select OAuth Applications tab, and click on Add Application.
Now, you will have to type the Application Name and select Active and click Save.
Now the following box will open containing the Client ID and Client Secret. You can copy them by clicking on the
icon and pasting them unto PCC.
NOTE | You will have to save the Client Secret in a safe place as you will not be able to retrieve it back from OroCommerce once you click CLOSE.
If you want to Deactivate, Delete or Edit the application, click on the three dots on the right-hand side of the Application.
The following box will open with the three options as follows:
When you click on the Deactivate icon, you will get a confirmation message asking you if you are sure that you want to deactivate the application.
When you click on the Delete icon, you will get a confirmation message asking you if you are sure that you want to delete the application.
When you click on the Edit icon, you will get the option to edit the name of the application.
