COMMANDS

The ‘Command’ column/function is used to make changes to your spreadsheet depending on the desired outcome. This function can be used across all of the different data objects (i.e. products, customers, orders, etc.)
NEW: Will create a brand new entry in the data object
UPDATE: Will update the previous entry with the new information provided
DELETE: Removes existing entry from your storefront
MERGE: Will look for an existing record and update it if found. If there is no existing record, it will create a new record
REPLACE: Will delete existing record and create a new record based on the imported file columns
IGNORE: Do nothing

Export

When a team member wants to export a CSV of their products, orders, or customers (in any combination of the three) into a workbook, the EXPORT function would be used.
To start a New Export, click on the ‘New Export’ button
notion image
 
After selecting ‘New Export’, you will be given the option of which format you’d like the export to be in
notion image
 
Once a format has been selected, you will be given the choice of which pieces of information you would like to export.
  • *Please note that there are ‘How-To’ guides for each major topic (i.e. products, customers, etc.)
notion image
 
Once the selection has been completed of what you’d like to export, the ‘Export’ button will not be greyed out.
notion image
 
When you click on the ‘Export’ button, you will be brought to the staging page. Note that this action will work in the background and you will still be able to navigate away from the page as Dataguru processes your request.
notion image
 
Once the export has completed processing, you can download the file to your device by clicking on ‘Download Export File’
notion image
 
After the download has been completed to your local device, you will be able to open the file and make changes before importing.
notion image
 
You can look at previous jobs!

Import

There are two scenarios we’d like to point out when using the ‘Import’ functionality with Dataguru. We will discuss both scenarios depending on where you are on the merchant journey: Brand new import and import from a spreadsheet that has been changed through the Dataguru app.
  1. Brand new import
To begin, you can download the Dataguru spreadsheet template to have an understanding of the different columns and data that you can import. Click on the ‘Download Import Example’ button to begin the download as seen below.
notion image
The downloaded template will have all data objects available to change. Based on your needs and requirements, you can select which to change on the tabs below.
notion image
If you have data from a previous system or spreadsheet, ensure that the data is copied over to the template accordingly. Definitions of the columns can be found here (INSERT LINK TO HELP DOC DEFINITIONS)
After making any desired changes to the data set, save the file on to your local device to be imported into your Shopify store.
On the app main page inside of your Shopify store, you have 2 options to import the file.
Drag and drop the file into outlined square
notion image
Or
Select ‘Click to add file’ hyperlink to open your local drive
notion image
Both options produce the same result for an imported file.
Once you’ve selected the file you’d like to import, you will see a status bar that will indicate when the file is ready for import
notion image
Once the status bar has gone to ‘100%’, you will be automatically redirected to the staging area for the next option. The staging area gives you important information on the upcoming import.
 
ID: Numbered import being done. Done in sequential order
Type: Action being completed by the user
Details: Data types and amount of data that is being imported
State: Status of the import file
Format: PLEASE INSERT DEFINITION HERE
Time: When the action is being done
Result: Final file that is being actioned
notion image
 
In the staging area, there are 2 buttons that will let you import the file shown below. They both do the same function so select whichever is easiest for you!
notion image
Note that you can also cancel the import of the selected file if you’d like to make changes or import a different version by clicking the ‘Cancel’ button as seen below.
notion image
Once you’ve clicked the ‘Import’, the staging area will begin processing the file. Note that you are still able to cancel the import job during the processing. You are also able to navigate away from the page as the job will be done in the background.
💡
It is highly recommended that you do not make any changes to the items being imported in your Shopify store as this will affect the import job.
notion image
 
Once the file is done importing, you will see a green ‘Finished’ status bar. You are able to see the total updated pieces of information. You are also able to download the imported file and/or download the Import Result File (ADD DEFINITION HYPERLINK HERE)
notion image
  1. Importing from a file already filled out in template format
If you’ve been using the template provided by Dataguru already, the steps are exactly the same as above
After making any desired changes to the data set, save the file on to your local device to be imported into your Shopify store.
On the app main page inside of your Shopify store, you have 2 options to import the file.
Drag and drop the file into outlined square
notion image
Or
Select ‘Click to add file’ hyperlink to open your local drive
notion image
Both options produce the same result for an imported file.
Once you’ve selected the file you’d like to import, you will see a status bar that will indicate when the file is ready for import
notion image
Once the status bar has gone to ‘100%’, you will be automatically redirected to the staging area for the next option. The staging area gives you important information on the upcoming import.
 
ID: Numbered import being done. Done in sequential order
Type: Action being completed by the user
Details: Data types and amount of data that is being imported
State: Status of the import file
Format: PLEASE INSERT DEFINITION HERE
Time: When the action is being done
Result: Final file that is being actioned
notion image
 
In the staging area, there are 2 buttons that will let you import the file shown below. They both do the same function so select whichever is easiest for you!
notion image
 
Note that you can also cancel the import of the selected file if you’d like to make changes or import a different version by clicking the ‘Cancel’ button as seen below.
notion image
 
Once you’ve clicked the ‘Import’, the staging area will begin processing the file. Note that you are still able to cancel the import job during the processing. You are also able to navigate away from the page as the job will be done in the background.
💡
It is highly recommended that you do not make any changes to the items being imported in your Shopify store as this will affect the import job.
notion image
 
Once the file is done importing, you will see a green ‘Finished’ status bar. You are able to see the total updated pieces of information. You are also able to download the imported file and/or download the Import Result File (ADD DEFINITION HYPERLINK HERE)
notion image

Cancelling an Import Job Before Import Starts

Before you begin the import job, you are given the option to cancel the action using the ‘Cancel’ button as shown below
notion image
 
Once you click on the ‘Cancel’ button, the import job will be cancelled before beginning and a status of ‘Cancelled’ will appear in the staging screen
notion image

Cancelling an Import Job During Import Processing

If you click on the ‘Import’ button to begin the importing job and want to cancel the action, you can do so in the staging screen. By clicking the ‘Cancel’ button shown below, the import job will stop and the import action will not complete.
notion image
 
Once the ‘Cancel’ button has been clicked, you will see the ‘Cancelling’ process on the staging screen with the ‘State’ as ‘Cancelling’
notion image
 
After the cancel job has been completed, you will see the new state as ‘Cancelled’ as shown below.
notion image
 
To confirm that the import has been cancelled, the main Dataguru app section will show the job and the action that was taken as seen below.
notion image

Products Key Value Definitions

ID - Created automatically by Shopify to identify the product. Hint* If you are creating a new product, leave this empty and Shopify will do its thing!
SEO: URL Handle - This is the end of the URL for what your customers will be seeing e.g. https://dataguru.app/products/this-app-is-so-damn-awesome. Whatever you decide to put into the handle, the lettering will be changed to lowercase and remove improper symbols.
 
If you’re stuck on the handle and wonder if it will be selected, Data Guru will highlight the “most” acceptable format for Shopify’s standards. Note that you can only have a handle of up to 255 characters! If you decide to write out a paragraph…it will be truncated at 255 characters. No one’s judging here!
 
Hint* Handles make a HUGE impact on SEO so ensuring that you have a good handle is important for different search engines' scoring.
 
Command - UP TOP DEFINITIONS
Title - Name of the product that is MANDATORY
Description - This is how you want to describe your amazing products! It can be plain text or if you feel up to the challenge, you can jazz it up using HTML code (hint* if you need some help with HTML code check out our friends INSERT A LINK HERE to get some guidance)
Status - This is the status of the actual product! Is it ready to be sold? Sold already? Still working on it? You can decide through three different statuses
  • Active - Right and ready to be on your site and sold in all channels
  • Archived - Product isn’t available anymore anywhere on your site. Many merchants keep products in this status and are not deleted right away just in case they want the product to make a comeback!
  • Draft - The product is not quite ready to be displayed on your site as of yet.
Published - This let’s Data Guru know if the product should be published on any of your channels
Type - Highlights what the product is. Pants? Shorts? Tshirt? It’s all up to you! Note that you can have the same type for multiple products e.g. Blank pants, red pants, long pants, short pants can have the Type = Pants.
Vendor - Got a few different brands on your site? Only one? Just you? This is where you’d put who is supplying the goods
Tags - The magic of tags! Tags play an essential role in your Shopify journey and there are numerous ways to use them. For an in-depth discussion of what Tags are and how to use them, check out this Shopify Link (INSERT SHOPIFY DOC LINK HERE).
In Data Guru, you can update, change, or add tags right from the CSV for convenience. Values allowed are all CSV friendly inputs
Theme Template - This is basically allows you to specify another Template from your Theme for this specific Product.
SEO: Page Title - Page title for SEO optimization.
SEO: Meta Description - Page meta description for SEO optimization.
Created at - When you created the product stated with date and time in the format YYYY-MM-DD HH:MM:SS
Updated at - If you make any changes to your product, this will show the date and time of when it was changed in the format YYYY-MM-DD HH:MM:SS
Media: ID - Created automatically by Shopify to identify the media.
Media: Command - UP TOP DEFINITIONS
Media: Alt text - Alt text means “alternative text”, and it’s used within HTML code to describe images on websites. Alt-text is making social media more accessible by describing images so people with vision loss can understand.
Media: URL -
Custom collection: SEO URL handle  -
Smart collection: SEO URL handle -
Variant: ID - Variant ID which is essentially a combination of unique Option Values.
Variant: Command -  UP TOP DEFINITIONS
Variant: Position - Variant can be sorted in specific order, you can change the order by update this position.
Option1 name - The name of 1st Option.
Variant: Option1 value - The Value of Option1 Name.
Option2 name - The name of 2nd Option.
Variant: Option2 value - The Value of Option2 Name.
Option3 name - The name of 3rd Option.
Variant: Option3 value - The Value of Option3 Name.
Variant: Image - The link of the variant image.
Variant: Price - The price of the Variant item in the currency, which you have set for your Store.
Variant: Compare at price - The original price, if your Variant Price is a discounted price.
Variant: Charge tax - As a merchant, you might need to charge taxes on your sales, and then report and remit those taxes to your government. Although tax laws and regulations are complex and can change often, you can set up Shopify to automatically handle most common sales tax calculations.
Variant: Cost per item - The price for per item of the Variant
Variant: SKU - The Stock Keeping Unit of the product, to use in identify the product variant.
Variant: Barcode - Shopify officially supports UPC or ISBN barcode types, but you can put here any other barcode format.
Variant: Track quantity - Quantity of available product variants of your stock.
Variant: Continue selling - Continue selling means Shopily will still allow the customers to buy orders from your store even you are out of stock.
Variant: Available quantity - The remaining stock of your product.
Variant: This is a physical product - Mark this product is a physical product in Shopify.
Variant: Weight - The weight in the specified Variant Weight Unit.
Variant: Weight unit - The weight unit to show to your clients. Shopify will automatically convert grams to this weight unit.
Inventory incoming: location one -
Inventory incoming: location two -
Inventory available: location one - The quantity of available stock in certain Location one.
Inventory available: location two - The quantity of available stock in certain Location two.

Smart Collections Key Value Definitions

ID - Created automatically by Shopify to identify the Smart Collections item
SEO: URL Handle - This is the end of the URL for what your customers will be seeing e.g. https://dataguru.app/products/this-app-is-so-damn-awesome. Whatever you decide to put into the handle, the lettering will be changed to lowercase and remove improper symbols.
If you’re stuck on the handle and wonder if it will be selected, Data Guru will highlight the “most” acceptable format for Shopify’s standards. Note that you can only have a handle of up to 255 characters! If you decide to write out a paragraph…it will be truncated at 255 characters. No one’s judging here!
Hint* Handles make a HUGE impact on SEO so ensuring that you have a good handle is important for different search engines' scoring.
Command - UP TOP DEFINITIONS
Title - Name of the Smart Collection
Description - Description of the Smart Collection
Sort - Sort the order of Smart Collections
Theme Template - This is basically allows you to specify another Template from your Theme for this specific Smart Collection Product.
Image: URL - Link to the image. This link must be publicly available and direct link so that Shopify is able to download image from it.
Image: Alt text - By SEO best practices, it is strongly suggested that images have “alt text” specified, because this is how search engines know, what’s inside that image.
SEO: Page Title - Page title for SEO optimization.
SEO: Meta Description - Page meta description for SEO optimization.
Updated at - It will be automatically updated, whenever you change the data.
Condition: Must match -
Condition: Column -
Condition: Relation -
Condition: Value -
Product: ID - Created automatically by Shopify to identify the product item in the smart collection
Product: SEO URL handle - This is the end of the URL for what your customers will be seeing.
Product: Title - The title of the product

Custom Collections Key Value Definitions

ID - Created automatically by Shopify to identify the Custom Collections item
SEO: URL Handle - This is the end of the URL for what your customers will be seeing e.g. https://dataguru.app/products/this-app-is-so-damn-awesome. Whatever you decide to put into the handle, the lettering will be changed to lowercase and remove improper symbols.
If you’re stuck on the handle and wonder if it will be selected, Data Guru will highlight the “most” acceptable format for Shopify’s standards. Note that you can only have a handle of up to 255 characters! If you decide to write out a paragraph…it will be truncated at 255 characters. No one’s judging here!
Hint* Handles make a HUGE impact on SEO so ensuring that you have a good handle is important for different search engines' scoring.
Command - UP TOP DEFINITIONS
Title - The title of the Custom Collection
Description - The description of the Custom Collection
Sort - Sort the order of custom collections
Theme Template - This is basically allows you to specify another Template from your Theme for this specific Custom Collection Product.
Image: URL - Link to the image. This link must be publicly available and direct link so that Shopify is able to download image from it.
Image: Alt text - By SEO best practices, it is strongly suggested that images have “alt text” specified, because this is how search engines know, what’s inside that image.
SEO: Page Title - Page title for SEO optimization.
SEO: Meta Description - Page meta description for SEO optimization.
Updated at - It will be automatically updated, whenever you change the data.
Product: ID - Created automatically by Shopify to identify the product item in the custom collection
Product: SEO URL handle - This is the end of the URL for what your customers will be seeing
Product: Command - UP TOP DEFINITIONS
Product: Title - The title of the product.

Automatic Discounts Key Value Definitions

ID - Created automatically by Shopify to identify the Automatic Discounts
Title - The  title name of the Discounts.
Command - UP TOP DEFINITIONS
Discount type - You can create automatic discounts and discount codes to offer to your customers. Learn more about free shipping discounts, buy X get Y, and percentage and fixed amount discounts
Status - This is the status of the Automatic Discount:
  • Active - Right and ready to be on your site.
  • Archived - Discounts code isn’t available anymore anywhere on your site.
  • Draft - The discount code is not quite ready to be use on your site.
Discount value - You can offer your customers a fixed value, percentage, or shipping discount on products, collections, or variants in your store. If you sell online, then you can offer buy X get Y discounts to encourage customers to buy items.
Only apply discount once per order - This is a setting that allows you to limit the usage of the discount code.
Customer buys: Specific collection
Customer buys: Specific products
Customer buys: Specific variants
Customer gets: Quantity
Applies to: All products - This is a setting that allows you to apply this discount to all products.
Applies to: Specific collections - This is a setting that allows you to apply this discount to the specific collections.
Applies to: Specific products - This is a setting that allows you to apply this discount to specific products.
Applies to: Specific variants - This is a setting that allows you to apply this discount to specific variants.
Minimum purchase amount - This is the setting that allows you to set the minimum purchase amount for use this discount.
Minimum quantity of items - This is the setting that allows you to set the minimum quantify of iterms for use this discount.
Maximum number of uses per order - This is the setting that allows you to set the minimum number of uses per order for use this discount.
Starts at  - The start time of using this discount.
Ends at -  The end time of using this discount.

Customers Key Value Definitions

ID - Created automatically by Shopify to identify the customer
Email - Email information of your customer
Command - UP TOP DEFINITIONS
First name - The first name of your customer.
Last name -  The last name of your customer.
Phone - The phone number of your customer.
State - The state of the address of your customer.
Collect tax - This the tax basic on the setting of your store.
Note - The note of customer
Tags -
Created at - When you created the customer stated with date and time in the format YYYY-MM-DD HH:MM:SS
Updated at - It will be automatically updated, whenever you change the data.
Orders -
Spent
Address: ID - Created automatically by Shopify to identify the address ID of the customer
Address: Command - UP TOP DEFINITIONS
Address: First name - The first name of the address
Address: Last name -  The last name of the address
Address: Company - The company name of  the address
Address: Address -  The address 1 of the address
Address: Apartment, suite, etc. - The address 2, such as apartment, suite, etc.
Address: City - The city of the address
Address: Province - The province of the address
Address: Country/region - The country/regoin of the address
Address: Postal code - The postal code of the address
Address: Phone - The phone number of the address

Discounts Key Value Definitions

Draft Orders Key Value Definitions
ID - Created automatically by Shopify to identify the Draft Order
Name - The name of the draft order
Command - UP TOP DEFINITIONS
Status - The status of the draft order
Email - The email of the draft order
Note - The note of the draft order
Tags - The tags that use in the draft order
Created at - When you created the draft order stated with date and time in the format YYYY-MM-DD HH:MM:SS
Updated at - It will be automatically updated, whenever you change the data.
Currency - The currency that you set in the Shopify admin that use in this draft order.
Subtotal - The subtotal of amount of the draft order.
Discount: Reason - The reason of the discount for the draft order.
Discount: Type -  The type of discount that use in the draft order.
Discount: Value - The value of discount that use in the draft order.
Discount: Total - The total amount of discount that use in this draft order.
Shipping: Rate name - The rate name of the shipping rates which you can set in the Shopify admin, go to Setting -> Shipping and delivery.
Shipping: Price - The price of the shipping rate wich you can set in the Shopify admin, go to Setting -> Shipping and delivery.
Charge taxes - The charge taxes of the order base on the setting of your store.
Tax: 1 title - The title of the Tax 1
Tax: 1 rate - The rate of the Tax 1
Tax: 1 total - The total of the Taxt 1
Tax: 2 title - The title of the Tax 2
Tax: 2 rate - The rate of the Tax 2
Tax: 2 total - The total of the Taxt 2
Tax: 3 title - The title of the Tax 3
Tax: 3 rate - The rate of the Tax 3
Tax: 3 total - The total of the Taxt 3
Tax: Total - The total amount of tax.
Total - The total amount of the order.
Customer: Email - The email of the customer.
Customer: First name - The first name of the customer.
Customer: Last name - The last name of the customer.
Customer: Phone - The phone number of the customer.
Customer: State - The state of the customer’s order
Customer: Note - The note of the customer’s order
Customer: Tags - The tags of the order
Line item: Title - The title of the product that the workflow adds to an order.
Line item: Name - The name of the product that the workflow adds to an order.
Line item: Variant ID - The product variant GID identifies the product that is added to the order.
Line item: SKU - The unique identifier of the product that the workflow adds to an order.
Line item: Quantity - The amount of product that the workflow adds to an order. The quantity must be greater than zero.
Line item: Price - The price of the line item
Line item: Discount reason - The reason of the discount for the line item.
Line item: Discount type - The type of discount for the line item
Line item: Discount value - The value of discount for line item
Line item: Discount total - The total amount of discount for line item
Line item: Taxable - The setting of taxable for line item
Line item: Requires shipping - The setting of required shipping for the line item
Line item: Weight - The actual weight of the line item
Line item: Weight unit - The weight unit of the line item
Line item: Tax 1 title - The tax title 1 of the line item
Line item: Tax 1 rate - The tax rate 1 of the line item
Line item: Tax 1 price - The tax price 1 of the line item
Line item: Tax 2 title - The tax title 2 of the line item
Line item: Tax 2 rate - The tax rate 2 of the line item
Line item: Tax 2 price - The tax price 2 of the line item
Line item: Tax 3 title - The tax title 3 of the line item
Line item: Tax 3 rate - The tax rate 3 of the line item
Line item: Tax 3 price - The tax price 3 of the line item
Line item: Tax total - The total tax amount of the line item
Line item: Total - The total amount of the line item
Shipping address: First name - The first name of the receiver of the shipping address
Shipping address: Last name - The last name of the receiver of the shipping address
Shipping address: Company - The company name of the shipping address
Shipping address: Address - The address of the shipping address, such as street name, etc.
Shipping address: Apartment, suite, etc. - The address of the shipping address, such as apartment, suite, etc.
Shipping address: City - City of the shipping address
Shipping address: Province - Province of the shipping address
Shipping address: Country - Country of the shipping address
Shipping address: Postal code - Postal code of the shipping address
Shipping address: Phone - Phone number of the shipping address
Billing address: First name - First name
Billing address: Last name - Last name
Billing address: Company - company name of your billing address
Billing address: Address - address of the billing address
Billing address: Apartment, suite, etc. - Details address such as Apartment, suite of the billing address
Billing address: City - City of the billing address
Billing address: Province - Province of the billing address
Billing address: Country - Country of the billing address
Billing address: Postal code - Postal code of the billing address
Billing address: Phone -  phone number of the billing address

Orders Key Value Definitions

ID - Created automatically by Shopify to identify the order
Name - The name of the order.
Command - UP TOP DEFINITIONS
Status - The status of the Order.
Email - The email address of this order.
Note - The note of this order.
Tags -
Created at - When you created the order stated with date and time in the format YYYY-MM-DD HH:MM:SS
Updated at - It will be automatically updated, whenever you change the data.
Currency - The currency that use in this order.
Subtotal - The subtotal of this order
Discount: Reason - The reason of using this discount.
Discount: Type - The type of this discount, like buy X get Y, etc.
Discount: Value - The value of this discount.
Discount: Total - The total amount of this discount.
Shipping: Rate name - The rate name of the shipping rates which you can set in the Shopify admin, go to Setting -> Shipping and delivery.
Shipping: Price - The price of the shipping rate wich you can set in the Shopify admin, go to Setting -> Shipping and delivery.
Charge taxes - The charge taxes of the order base on the setting of your store.
Tax: 1 title - The title of the Tax 1
Tax: 1 rate - The rate of the Tax 1
Tax: 1 total - The total of the Taxt 1
Tax: 2 title - The title of the Tax 2
Tax: 2 rate - The rate of the Tax 2
Tax: 2 total - The total of the Taxt 2
Tax: 3 title - The title of the Tax 3
Tax: 3 rate - The rate of the Tax 3
Tax: 3 total - The total of the Taxt 3
Tax: Total - The total amount of tax.
Total - The total amount of the order.
Customer: Email - The email of the customer.
Customer: First name - The first name of the customer.
Customer: Last name - The last name of the customer.
Customer: Phone - The phone number of the customer.
Customer: State - The state of the customer’s order
Customer: Note - The note of the customer’s order
Customer: Tags - The tags of the order
Line item: Title - The title of the product that the workflow adds to an order.
Line item: Name - The name of the product that the workflow adds to an order.
Line item: Variant ID - The product variant GID identifies the product that is added to the order.
Line item: SKU - The unique identifier of the product that the workflow adds to an order.
Line item: Quantity - The amount of product that the workflow adds to an order. The quantity must be greater than zero.
Line item: Price - The price of the line item
Line item: Discount reason - The reason of the discount for the line item.
Line item: Discount type - The type of discount for the line item
Line item: Discount value - The value of discount for line item
Line item: Discount total - The total amount of discount for line item
Line item: Taxable - The setting of taxable for line item
Line item: Requires shipping - The setting of required shipping for the line item
Line item: Weight - The actual weight of the line item
Line item: Weight unit - The weight unit of the line item
Line item: Tax 1 title - The tax title 1 of the line item
Line item: Tax 1 rate - The tax rate 1 of the line item
Line item: Tax 1 price - The tax price 1 of the line item
Line item: Tax 2 title - The tax title 2 of the line item
Line item: Tax 2 rate - The tax rate 2 of the line item
Line item: Tax 2 price - The tax price 2 of the line item
Line item: Tax 3 title - The tax title 3 of the line item
Line item: Tax 3 rate - The tax rate 3 of the line item
Line item: Tax 3 price - The tax price 3 of the line item
Line item: Tax total - The total tax amount of the line item
Line item: Total - The total amount of the line item
Shipping address: First name - The first name of the receiver of the shipping address
Shipping address: Last name - The last name of the receiver of the shipping address
Shipping address: Company - The company name of the shipping address
Shipping address: Address - The address of the shipping address, such as street name, etc.
Shipping address: Apartment, suite, etc. - The address of the shipping address, such as apartment, suite, etc.
Shipping address: City - City of the shipping address
Shipping address: Province - Province of the shipping address
Shipping address: Country - Country of the shipping address
Shipping address: Postal code - Postal code of the shipping address
Shipping address: Phone - Phone number of the shipping address
Billing address: First name - First name
Billing address: Last name - Last name
Billing address: Company - company name of your billing address
Billing address: Address - address of the billing address
Billing address: Apartment, suite, etc. - Details address such as Apartment, suite of the billing address
Billing address: City - City of the billing address
Billing address: Province - Province of the billing address
Billing address: Country - Country of the billing address
Billing address: Postal code - Postal code of the billing address
Billing address: Phone -  phone number of the billing address
 
badge