This page summarises release information for Patchworks releases to Production between 8th November 2022 and 31st January 2023.
Patchworks BI is a secure, fully hosted and managed Reporting as a Service (RaaS) solution, managed by a dedicated team of BI analysts and data engineers.
Built upon the Microsoft Power BI platform with data hosted in a cloud data warehouse, fast, accurate, meaningful data insights are delivered via a suite of reports covering:
Customers can subscribe to one of three Patchworks BI tiers: standard, professional and enterprise.
Payload-level custom scripts
Payload-level custom scripts can be used for cases where you need to manipulate the payload that gets pulled from a source system before it is pushed to your required destination.
For example, you might add a Patchworks service to sync products between two systems, but need to exclude certain SKUs from the sync. If your source system does not support filtering at this level, a payload-level custom script can be defined to perform this operation.
Payload-level scripts are added and tested within the custom scripts area, before being added to required services.
View & restore previous versions of a custom script
An audit log is now available for every custom script. If an existing script is changed and saved, those changes are logged and differences can be viewed in an audit log via a new view changes button:
From here, you can choose to restore a previous version.
Add connector wizard
A new add connector wizard steps you through the process of adding a connector in a fresh, intuitive way:
For customers using our Stockr application to align stock levels across multiple Shopify stores, a new Stockr summary is available within the Patchworks dashboard:
Here, you can view transaction totals and associated costs for any given time period. You can also download transactions in CSV format.
NetSuite Suitetalk
Entity
Pull (as source)
Push (as destination)
Inventory Planner
Entity
Pull (as source)
Push (as destination)
Updated features
Enhanced audit logs
Audit logs have an updated UI and more events are logged - for example:
Events are displayed by date. Each event is shown with 'headline' information in a shaded header bar.
Click the associated details option for an event to view a detailed log:
Increased auto-refresh frequency for sync logs
The auto-refresh frequency for sync logs has been increased as below:
Sync status
Auto-refresh frequency (seconds)
Roles & permissions
In certain areas of the Patchworks dashboard (for example, service source/destination settings and mappings), a JSON editor is available.
Typically, these editors are only required by Patchworks administrators however - upon request - users may be assigned a new advanced editor role which provides access to JSON editors throughout the dashboard.
Affected feature
Fixed issue with...
Patchworks #
Shopify OAuth2 authentication
Shopify OAuth2 authentication.
A user account could be created without assigning a role.
Sending products with the same SKU to two different target systems.
Save option not available for client admin users
Default filters were not applied if 'run service' was triggered without changing any options.
Default selection on existing credentials for list options.
