OzSale Branded Portal
Summary
OZSALE & NZSALE (MYSALE Group) is the leading online shopping club in Australia and New Zealand and your doorway to affordable designer fashion.
This help guide will walk you through how you can onboard yourself on to the OZSALE & NZSALE Marketplaces in order to sync products, stock, orders and order updates via BigCommerce.
Service Fee
The first thing you need to do is to pay for the service fee to use this application.
- When you first login to https://ozsale.crescodata.com/ you will see a warning message - "Payment is required to activate your services. Click here to make your payment."
- The quarterly subscription is AUD$165 inc GST and will automatically be charged quarterly.
- Service can be terminated at any time. There is no refund offered for this service.
- This is required before any services can be activated.
- Clicking the link, will take you through to a payment page.
- Please note this is a quarterly payment, with a minimum term of 12 months.
- Once payment has been made, this will redirect you to our Branded Portal to complete setup.
Manage Billing
You can edit your credit card details by clicking on the top right icon and selecting Manage Billing.
This will direct you to a Stripe hosted page to change / update your credit card details.
It also allows you to view your previous billing history.
Video Guide
Settings
Connection details
Upon logging into https://ozsale.crescodata.com/, first go to "Settings" from the left navigation.
Here you will be asked to add in your connections details for BigCommerce and OZSALE & NZSALE . Please review the below on how you can access these details.
OZSALE & NZSALE
- This will be provided by your OZSALE & NZSALE account manager.
BigCommerce
- Log in to your BigCommerce admin account: https://login.bigcommerce.com/login
- From the left navigation select Advanced Settings.
- Next select API Accounts.
- Click Create API Account and select Create V2/V3 API Token.
- Under oAuth Scopes select the follow permissions:
- Carts - Modify
- Checkout Content - Modify
- Customers - Modify
- Information & Settings - Modify
- Orders - Modify
- Order Transactions - Modify
- Create Payments - Create
- Get Payment Methods - read-only
- Stored Payment Instruments - modify
- Products - Read-only
- Upon Save it will provide you with the details to load into the Branded Portal.
- Store Hash - This can be found as below when creating the API account:
Once completed, click "Next"
Products
- Stock buffers - If you want to add a buffer to stock retrieved from BigCommerce, then add a <number> we should deduct to send to OZSALE & NZSALE .
- Next toogle both of the BigCommerce and OZSALE & NZSALE services from "Not Active" to "Active".
- Click "Next".
Orders
- Toogle both of the BigCommerce and OZSALE & NZSALE services from "Not Active" to "Active".
- Click "Save" to complete the setup.
This will schedule the download of products from BigCommerce. Also sync any future orders from OZSALE & NZSALE to BigCommerce.
Publishing products to OZSALE & NZSALE
Below is the process of how you publish products from BigCommerce to OZSALE & NZSALE. These steps must be taken in order for products to publish, so please follow them carefully.
Category allocation
Category mapping can be done in two different ways - Bulk Mapping or Custom Fields.
Noting that you can do Bulk Mapping and overwrite at a product level with a custom field.
Bulk Mapping
This allows you to map the BigCommerce Category to an OZSALE category by doing the below:
- Go to "Products"
- Go to the "Mappings" tab.
- Here you will see all unique Source Categories to map to an OZSALE category.
- The Source Category is based on the category path with the lowest sort order.
- Noting you can:
- Filter Source Categories by keyword.
- You can copy an OZSALE category mapping and paste to other Source Categories that will use the same category.
- You can filter an OZSALE category by keyword or drill down.
Custom Field
Below is how you can create a BigCommerce "custom field" to define what category the product should be published to in OZSALE & NZSALE.
Products will only be published to OZSALE & NZSALE , if it has one of these tags.
-
Go to the “Categories” link from the left navigation.
-
Click on the "Export" button to export all category.
- This will link you to "Exports" where you can download the OZSALE & NZSALE category list.
-
Review the category list and find the categories most relevant to your products.
-
Go into BigCommerce and follow the steps outlined HERE to bulk apply custom fields to products.
- Custom field name - OZ-ID
- Value - <Ozsale Category>
-
Example - If we want to list a product under “Clothing > Mens > Activewear > Compression Clothing” in OZSALE & NZSALE , the value for the custom field "OZ-ID" would be “90aa74db-6f7f-452c-8640-3223baf8aca2”
-
We will then sync the product to OzSale automatically - No additional action required.
NOTE - We only sync products to OZSALE & NZSALE that has a custom field and value listed above.
Country of Origin
If you can to define the country of origin per product, then please follow the below steps:
- Go into BigCommerce and follow the steps outlined HERE to bulk apply custom fields to products.
- Create a custom field named "OZ-country"
- The value will be the “Alpha-2” Country code list HERE
- Example if the product was made in Australia then the custom field name would be "OZ-country" and the value would be "AU".
Shipping Policies
If you want to define a shipping policy per product, then please follow the below steps:
- Go into BigCommerce and follow the steps outlined HERE to bulk apply custom fields to products.
- Create a custom field named "OZ-Shipping_policies"
- The value will be the policyID is located in Mysale as below:
Markup / Markdown Price
If you want to markup or markdown the price from Bigcommerce to OzSale per product, then please follow the below steps:
- Go into BigCommerce and follow the steps outlined HERE to bulk apply custom fields to products.
- Create a custom field named "OZ_adjustment_price"
- Markup - The value for a percentage markup would be "10" to increase the price by 10%.
- Markdown - The value for a percentage markdown would be i.e. "-10" to decrease by 10%.
Deactivate a product
If you have previously created a product and want to deactivate the product, you can do this by:
- Custom Field:
- Go into BigCommerce and follow the steps outlined HERE to bulk apply custom fields to products.
- Create a custom field named "OZ-deactivate"
- The value will be "y" to deactivate.
- Remove the Custom Field category value.
Product Diagnostics
The below video explains the Diagnostic tab of the Product Sync area.
Noting that the below video portal is slightly different in that:
- Integration Diagnostics is the same as Diagnostics in the OZSALE portal.
- Results is the same as Sync Results in the OZSALE portal.
Orders
-
Once an order is placed on OZSALE & NZSALE it will sync to BigCommerce.
- Orders will be auto-acknowledged back to OZSALE & NZSALE .
- Shipment update
- You can then go into BigCommerce and fulfill the order, ensuring a tracking number and carrier is added.
- Click on "Ship Items"
- Add a Tracking Number and Carrier.
- Full cancellation
- Change status of order to “Cancelled” on BigCommerce
- Note: This can only be done before any shipment is created
- Partial cancellation/refunds
- Refund/ship individual order lines on BigCommerce
- Ship/refund the rest of the order lines
- Change status of order to “Shipped” or “Completed”
- Note: Refunds on order lines cannot be created after a shipment has been created for it, and vice versa. If a further update needs to be done to the order line after a shipment or refund has been created, a manual change on OZSALE & NZSALE will have to be made.
- This will then publish an order status update to OZSALE & NZSALE.
Order Diagnostics
The below video explains the Diagnostic tab of the Order Sync area.
Noting that the below video portal is slightly different in that:
- Integration Diagnostics is the same as Diagnostics in the OZSALE portal.
- Results is the same as Sync Results in the OZSALE portal.