Summary

Woolworths MarketPlus allows you to gain visibility on leading websites such as Big W, Woolworths, and the Everyday Rewards App, ensuring your products are seen by a diverse and active customer base.

This help guide will walk you through how you can onboard yourself on to the Woolworths MarketPlus 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://marketplus.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.

Settings

Connection details

Upon logging into https://marketplus.crescodata.com/, first go to “Settings” from the left navigation.

Here you will be asked to add in your connections details for BigCommerce and Woolworths MarketPlus. Please review the below on how you can access these details.

Woolworths MarketPlus

• Seller ID & Seller Token – This will be provided by your Woolworths MarketPlus 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.
  • Client ID
  • Access Token
  • Store Hash – This can be found as below when creating the API account:

Once completed, click “Next”

Products

Woolworths MarketPlus

• Product Sync Flags
  • Products – Whether to sync product attributes.
  • Status – Whether to update product status.
  • Stock – Whether you want to sync stock updates.
  • Price – Whether prices should be synced.
• Create Products – Whether you want to create new products into Woolworths MarketPlus.
• Next toggle both of the BigCommerce and Woolworths MarketPlus services from “Not Active” to “Active”.
• Click “Next”.

Orders

• Allow Cancellations – If you want to sync cancellations from Woolworths MarketPlus to Shopify or vice-versa.
• Allow Refunds – If you want to sync refunds from Woolworths MarketPlus to Shopify.
• Allow Fulfillment – If you want to sync fulfillment details from Shopify to Woolworths MarketPlus.
• Toggle both of the BigCommerce and Woolworths MarketPlus 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 Woolworths MarketPlus to BigCommerce.

Publishing products to Woolworths MarketPlus

Below is the process of how you publish products from BigCommerce to Woolworths MarketPlus. 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 Woolworths MarketPlus 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 Woolworths MarketPlus 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 Woolworths MarketPlus category mapping and paste to other Source Categories that will use the same category.
  • You can filter an Woolworths MarketPlus 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 Woolworths MarketPlus.

Products will only be published to Woolworths MarketPlus, 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 Woolworths MarketPlus 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 – MP-ID
  • Value – <MarketPlus Category>

  • Example – If we want to list a product under “Appliances > Coffee Makers > Coffee Grinders” in Woolworths MarketPlus, we would apply the tag “MP-ID_2687”

• We will then sync the product to Woolworths MarketPlus automatically – No additional action required.

NOTE – We only sync products to Woolworths MarketPlus that has a custom field and value listed above.

Rules

• Go to Products from the left navigation.
• Then the Rules tab
• For the Cresco Attributes – This is to setup rules for common attributes like Title, Price or Stock. See examples HERE

• Go to Products from the left navigation.
• Then the Rules tab.
• And the Destination Rules sub-tab.
• Here you will see a list of all required attributes that require rules before syncing to Woolworths MarketPlus:
  • Condition
  • Weight Unit
  • Dimension Unit
  • Requires Shipping
  • Shipping Cost Category
    • 1 – If Flat fee per order.
    • 2 – If using a Custom Freight Scheme.
    • 3 – If Flat per qty.
  • Custom Freight Scheme Id – Provided by Woolworths MarketPlus team.
  • Shipping Cost Standard – If using 1 or 3 Shipping Cost Category.
  • Request Freight Quote
  • Has 48 Hours Dispatch
  • Is Direct Import
  • Delivery Time
  • Max Days For Delivery

Deactivate a product

If you have previously created a product and want to deactivate the product, you can do this by:

• 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 Woolworths MarketPlus portal.
• Results is the same as Sync Results in the Woolworths MarketPlus portal.

Orders

• Once an order is placed on Woolworths MarketPlus it will sync to BigCommerce.

• Orders will be auto-acknowledged back to Woolworths MarketPlus.
• 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 onWoolworths MarketPlus will have to be made.
• This will then publish an order status update to Woolworths MarketPlus.

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 Woolworths MarketPlus portal.
• Results is the same as Sync Results in the Woolworths MarketPlus portal.

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.

Troubleshooting

How do I review the exchange rate used to convert to NZD?

If you selected Global Conversion Rate to convert your prices to NZD, you can review the exchange rate used by:

• Go to Settings and the Product section.
• Under the NZD Currency Conversion Method if you Global Conversion Rate is selected, you will see the text – View the current exchange rate by clicking the here
• After clicking the link, you will be redirected to currency exchange page. Here you can change the From currency and the date you want to review the exchange rate for.