Big Commerce Authorization, Database and Limits
Summary of Changes: (The purpose of this table is to keep traceability and Product team to highlight the things that were changed into the scope, based on comments or discussions)
| Date | Version | Name | Applied changes |
|---|---|---|---|
| 09/08/2023 | v1.0 | Bogomil Pavlov | First Publish |
| 13.12.2023 | v1.1 | Bogomil Pavlov | Variant Update Flag |
| 06.08.2024 | v1.2 | Bogomil Pavlov | Obsolete Default Payment Id |
| 23.08.2024 | v1.3 | Bogomil Pavlov | Tax control flag |
| 27.08.2024 | v1.4 | Bogomil Pavlov | Additional Categories |
| 27.08.2024 | v1.5 | Bogomil Pavlov | Custom Fields |
The Authorization happens with the store hash and the X-Auth-Token.
Both details are obtained from Big Commerce Portal and do not change so we want to store them in Big Commerce Account a dependent table of Account.
We need to push X-Auth-Token as a header in every request while the hash is part of the URL.
Database Structure
| Account Big Commerce | |||
|---|---|---|---|
| Field Name | Field Type | Default Value | Required |
| Store Hash | text field | N/A | Yes |
| Access Token | encrypted field | N/A | Yes |
| Default Carrier | dropdown | N/A | No |
| <v1.2>Default Payment Id (obsolete) | text field | N/A | No</v1.2> |
| Default Weight(g) | text field | N/A | No |
| Big Commerce Location | dropdown | N/A | No |
| <v1.3>Refund with Tax | checkbox | No | No<v1.3> |
| Order Big Commerce | |||
|---|---|---|---|
| Field Name | Field Type | Default Value | Required |
| Handling Cost | number | N/A | No |
| Wrapping Cost | number | N/A | No |
| Product Account Big Commerce | |||||
|---|---|---|---|---|---|
| Field Name | Field Type | Default Value | Import | Required | Readonly |
| Featured Product | checkbox | 0 | Yes | No | No |
| Main Image | text field | N/A | Yes | No | No |
| More Images | text field | N/A | Yes | No | No |
| Variant Id | number | N/A | No | No | No |
| <v1.1>Variant Update</v1.1> | radio (Pending, Sent, Not Needed, Error) | Not Needed | No | No | No |
| <v1.4>Additional Categories | Table - simple with Text Boxes only (same as More Picture URL) | N/A | Yes | No</v1.4> | No |
| <v1.5>Custom Fields | Table - simple with Text Boxes only (same as Item Specifics but with 3 columns) | N/A | No | No</v1.5> | Yes |
Limits
TBC