TradeSquare
Summary
TradeSquare is an Australian B2B trading platform for Australian SMEs to source products from Australian distributors and wholesalers.
Connecting to Tradesquare via Maropost Commerce Cloud
Customers of Maropost Commerce Cloud can connect to TradeSquare using the TradeSquare Addon App (powered by CrescoData) available in the Maropost Add-on Store.
If you require support on how to connect your Maropost Commerce Cloud account to TradeSquare, please visit the Maropost Commerce Cloud support page - Maropost Commerce Cloud App Support Hub.
Overview
The TradeSquare addon allows you to sell products on TradeSquare.com.au while still taking advantage of Maropost Commerce Cloud's powerful back end system for order management.
Orders placed on TradeSquare.com.au are downloaded into Maropost Commerce Cloud for processing. Once they are dispatched, Maropost Commerce Cloud sends the status back to your website so that customers are notified of fulfilment, and can track the delivery.
In addition, stock levels maintained in Maropost Commerce Cloud are automatically synced to TradeSquare.com.au.
SETUP VIDEO
Connect Maropost to Tradesquare
- In your Maropost Commerce Cloud control panel select the Addons menu.
- Locate the TradeSquare addon in the Sales Channels section, and click the Install button.
- Confirm any additional costs by clicking the Install and Confirm button.
- This will redirect you to the TradeSquare app to configure your setup.
- The TradeSquare App is powered by CrescoData, so you will first need to accept their terms of service and privacy policies.
SETTINGS
What would you like to sync
Turning on one or both of the below syncs will show the authentication details required for TradeSquare and the settings available to configure your setup between TradeSquare and Maropost Commerce Cloud.
- Products
- Orders
SYNC TIMING
Product Settings
- Connection details
- Click on the button below:
-
- This will ask you to login with your TradeSquare Mirakl account details.
- Next you will need to authorize CrescoData by clicking "Confirm" to allow the syncing of data between TradeSquare and your eCommerce platform.
-
- This will redirect you back to the Portal and you should see a green tick under TradeSquare Connection Details.
Once completed, click "Next"
- Sync
- New Products & Attributes - Whether to allow new product creations & updating of existing product information such as category, descriptions, names, variants & other attributes from Maropost Commerce Cloud.
- Offers - Whether to allow the syncing of offer descriptions from Maropost
- Stock - Whether stock should be synced from Maropost.
- Prices - Whether prices should be synced from Maropost.
- Status - Whether to allow disabling SKUs on TradeSquare when the SKU is Unapproved on Maropost.
- Image Mappings - The mapping of how you want to order Maropost Images to TradeSquare images.
Product Details
- Categorisation Method - What Maropost product category should be used to map to a TradeSquare category.
- Map From Content-Type - The Maropost category attribute to map to a TradeSquare Category would be one of the “/_cpanel/content_types” attributes.
- Map From Custom Field - The Maropost category attribute to map to a TradeSquare Category would be one of the “/_cpanel/miscfield_inventory” attributes.
- Category Attribute - This dropdown will change based on the “Categorisation Method” selected and based on what attribute is selected, this will be used to map to TradeSquare categories - NOTE - If this is selected then we expect the TradeSquare CategoryID to be the value of this attribute.
- Description Attribute - Maropost description attribute to use when syncing products. Only applicable if you have a custom description attribute you want to use over the default one.
- Name Attribute - Maropost product name attribute to use when syncing products. Only applicable if you have a custom name attribute you want to use over the default one.
- Weight Attribute - Maropost weight attribute used to sync to TradeSquare, if you are using a custom attribute.
Shipping Details
- Default Lead Time To Ship (days) - A default lead time (in days) to apply to all products we create and update.
Price & Quantity
- Virtual Stock Qty - The quantity to set on the marketplace for virtual Maropost products.
- Stock Buffer - If set, we will subtract this amount from the available stock quantity we import from Maropost.
- Price Group - Maropost price group to use when syncing the price. You can leave this empty and enable Allow Default Price Fallback to use the default price group.
- Use Promo Price - Whether to sync promotional pricing from the selected Maropost price group, to TradeSquare.
Other Product attribute logic
Below are some TradeSquare attributes that are mapped to default Maropost fields and therefore are not settings:
- Units per pack - This is mapped to the “Mult” field in Maropost) as below:
- Unit Type - This value is “Package” if the number of units per pack (Mult) > 1, else “Single”.
- Made in AU and Manufacture Location - Based on the Manufacture Country Attribute and Default Manufacture Country setting. If set to AU made_in_au will be true. manufacture_location will then be set accordingly.
Order Settings
Shipping Service / Courier Mappings
The shipment service mappings for order fulfillments. This is required so we can select the correct shipping service when fulfilling orders on the marketplace.
Order Details Mapping
- Maropost Payment Method - The payment method to use when creating orders on Maropost.
- Maropost Shipping Method - The shipping method to use when creating orders on Maropost. Leave blank to not set any shipping methods during order creations.
- Maropost New Order Status - The status to set on new orders from TradeSquare that are imported to Maropost).
-
Maropost Customer User Group - Customer group to apply to contacts created in Maropost when an order is created.
Notification Settings
Allows you to opt into receiving key email alerts that require action within the App.
- Notification Hour - When you would like to receive the daily email summary.
-
Order Sync Errors - Opt in to receiving a summary of all order errors between Maropost and TradeSquare.
- Product Sync Errors - Opt in to receiving product error notifications when publishing to TradeSquare.
- Mapping Errors - Opt in to receiving category mapping errors that requires action.
At any time you can unsubscribe to these notifications either within the App or via a link in the email.
PRODUCT SYNC
Upon clicking “Save”, this will validate your TradeSquare credentials and trigger the downloading of products from Maropost for mapping. This process will take 5-10mins, so please review after this period of time.
From the left navigation, click on “Product Sync” to view the products downloaded from Maropost.
Products will only be synced if “Approved To Show On TradeSquare” is set to approved in Maropost, so please complete this step first before proceeding with Category mapping.
NOTE - Product & category mapping is required before products are published to TradeSquare.
Category Mapping
- Once all products are downloaded, click "Next" from the "Settings" page.
Categorisation Method - Maropost standard attribute
- Here we will summarise all unique Maropost categories across all products under the “Source Categories” column.
- For every “Source Category” click into “Select Category Mapping” to select the most appropriate TradeSquare category.
- NOTE - Click on the source category will link you to all products allocated to this Maropost category.
Categorisation Method - Custom Maropost Attribute.
- You need to ensure that the TradeSquare categoryID is the value of this custom Maropost attribute.
- This will auto-map categories and you can skip this step.
TradeSquare Attributes
Now that you have mapped all categories, the next step is to map TradeSquare specific attributes.
Grouping single products together
If you have set up your product variants in Maropost as individual products and not as a variant product, please follow the below on how they are to be grouped when sending to TradeSquare:
- First you need to set up a custom attribute in Maropost called “TradeSquare Group Title”.
- Next you need to bulk update products which should be grouped to have the same “TradeSquare Group Title”.
- Now within the “TradeSquare Attributes” under the “TradeSquare Attribute” dropdown is an option called “Group Title”.
- This needs to be mapped to the “Source Attribute” of “TradeSquare Group Title”.
- Now for all products which have the same “Group Title” they will display in TradeSquare as a single product of different variants.
Mapping Size / Colour or Item Variants
There are a few ways to map Size / Colour or Item Variants, depending on a few things:
- Size / Colour - These are TradeSquare specific attributes that can be mapped from the Source attributes of Size / Colour (Mapped from Maropost) “Specifics / Filters”) or a “Custom Field” from Maropost.
- These fields have a dropdown list of accepted values and if you can map all Maropost values to TradeSquare values, then this is the best option.
- If the values from Maropost cannot be mapped to TradeSquare values, then we recommend to map the Source “Size” or “Color” to the TradeSquare attribute of “Item Variant” 1, 2 or 3 as these attributes allow for any values.
- Item Variants - TradeSquare have three “Item Variant” attributes that can be mapped to a Maropost source attribute. As a default, this is mapped to the non-size or colour, item specifics in Maropost ). However, if a manual overwrite is required, you may choose to map these fields to either “Size” / “Color” as above or to provide a custom field with values on how the product varies. If multiple “Item Variant” attributes are mapped we will separate the values with a “|” divider.
- If you have chosen to overwrite the item variant with custom fields, this will only apply to products with non-null values for the custom fields. Products with null custom field values will still automatically map non-size and colour item specifics from Maropost.
Other Product attributes
- Click on “TradeSquare Attributes” to see what attributes are available in TradeSquare. If you want to map one of these attributes select it from the dropdown.
- Now click on “Source Attributes” where you can select from “Mapped attributes or “Custom Fields”
- Mapped Attributes - Color, Material and Size are pulled from Maropost products Item Specifics which have the text colour, colour, size, or material in the option name (case insensitive). Brand is pulled from the default Brand Maropost attribute.
- Custom Fields- These will list the Misc fields of products we’ve pulled so far that have values.
- Once you have selected the appropriate Maropost attribute, click “map”.
- This will bring up all unique Maropost values for products to list under this category.
- You will then map this value to an appropriate TradeSquare value.
NOTE - If the values in Maropost are the same as the values available in TradeSquare, you can click “Forward Unmapped”. This will send the values from Maropost to TradeSquare, however if can click the dropdown to overwrite if required.
- Repeat this process for all attributes applicable.
Preview
- Once categories and attributes have been mapped you can click “Next” and click on the “Complete & Publish” button.
- This will prompt a message to ensure that you have completed all mappings and that products can be published to TradeSquare. Only at the point of clicking “OK” will the products and offers be synced to TradeSquare.
- Under a product listing we also have two other tabs:
- Overview - If you want to review the payloads from Maropost and sent to TradeSquare.
- History Log - Provides a summary of all updates from Maropost and how this then updated TradeSquare. This is useful to see how stock has changed over time.
Exports
- This is to show the products we have attempted to sync to TradeSquare - Either successfully or unsuccessfully.
Diagnostics
- This tab summarises the updates we receive back from TradeSquare, upon product sync.
- Clicking into a specific error category will show what the issue is for resolution. Key ones being:
- Category missing.
- Attribute missing.
- No images
Republishing Products
If you want to republish your products after a settings change, follow the below steps:
- Go to the “Settings” page, change the settings required and click “Save”. This will highlight a prompt on how you can republish your products with the reflected setting.
- Go to the “Product Sync” page and click on the “Republish” button.
- This will popup a warning for you to finally click the “Re-publish” button.
- This will re-sync all the latest updates to TradeSquare.
Note - There is a daily limit on how many times you can republish. If you require additional republish, you will have to reach out for assistance.
ORDER SYNC
Imports
- This will show all imports received from TradeSquare and Maropost.
- Here you can also filter on a number of key attributes like Order # and order status. We also recommend to filter on “Integration” to see what has been imported from TradeSquare or Maropost.
- Clicking into a specific order will show:
- Overview - If you want to see the last payload received from TradeSquare to Maropost.
- History Tab - A summary of changes to the order over time.
- Listing - A simplified view of the order and items ordered.
Exports
- This will show all exports to TradeSquare and Maropost.
- Here you can also filter on a number of key attributes like Order # and order status. We also recommend to filter on “Integration” to see what has been exported to TradeSquare or Maropost.
- Clicking into a specific order will show:
- Overview - If you want to see the last payload received from TradeSquare to Maropost.
- History Tab - A summary of changes to the order over time.
- Listing - A simplified view of the order and items ordered.
Diagnostics
- Will summarise the messages from TradeSquare or Maropost and if any issues have occurred.
Health Dashboard
The Health Dashboard is about providing transparency through a one-page summary of a merchant's CrescoData setup, providing key actionables and a summary of performance at a glance.
Video Overview
Key Sync Types
Products
- No. of Products - Based on the number of products synced to a destination channel within the last 30 days. It is not the total number of products under your setup, only the products that have updated in the last 30 days.
- Percentage of Products with success - Based on a success response at a variant level as a percentage of all responses received over the past 30 days.
- Percentage of Products with warning - Based on a warning response at a variant level as a percentage of all responses received over the past 30 days.
- Percentage of Products with error - Based on an error response at a variant level as a percentage of all responses received over the past 30 days.
- Error Summary - Shows all error responses by high level category, with the ability to click into each category to see what actions are required to fix the error.
Orders
- New Orders - Last 7 Days - Total number of orders over the last 7 days, with a comparison to the last 7 days to see if sales have increased or decreased. Both numbers are clickable to review the specific orders within each time period.
- New Orders - Last 30 Days - Total number of orders over the last 30 days, with a comparison to the last 30 days to see if sales have increased or decreased. Both numbers are clickable to review the specific orders within each time period.
- Order Value - Last 30 Days - Total order value over the last 30 days, with a comparison to the last 30 days to see if sales have increased or decreased.
- Order Status - A summary of orders from the last 30 days and what status they are in.
- Total New Orders This Week - Graph showing order numbers per day, over the last 7 days.
- Error Summary - Shows all error responses by high level category, with the user clicking into each to see what actions are required to fix the error.