This macro is related to functionality of Ongoing SOAP API UpdateArticleMaterials described here:
https://developer.ongoingwarehouse.com/update-article-materials
Ongoing is a fast-growing, Swedish-based, software company that specializes in a web-based Warehouse Management System (WMS) for logistics-intensive companies such as 3PL and those managing their own warehousing. Read more in english: https://ongoingwarehouse.com/ or in swedish: https://ongoingwarehouse.se/
Effortlessly manage your warehouse data in regards to environmental and sustainability attributes, using our Excel-based tool built for the Ongoing’s SOAP API. With no programming or SOAP API expertise required, this solution enables you to bulk-edit and automate updates for product materials, environmental certifications, and energy usage data—all from a user-friendly Excel file that can also be filled in by your suppliers without the need of them integrating a complex system. This allows you to be cost efficient and stay on top of any environmental requirements related to your products.
Our macro-enabled tool is pre-configured to communicate with the Ongoing’s SOAP API for the UpdateArticleMaterials functionality. Input your data into a structured Excel template, click a button, and let the tool handle everything from sending data to receiving SOAP API XML Responses. This allows you to see which rows are posted or if so, why they have failed to post at any given time.

Manage Environmental Data with Ease
The macro supports advanced features that align with Ongoing’s focus on sustainability, including:
- Recycled Material Information: Update whether products or packaging contain recycled materials or are recyclable.
- Energy Specifications: Record energy usage attributes, such as estimated hours of use, kilowatt hours per hour, and energy sources, ensuring compliance with sustainability standards.
- Environmental Certifications: Update certifications for your articles, such as certification codes, names, and operations, to reflect your commitment to environmental responsibility.
Key Benefits:
- Comprehensive Environmental Reporting: Capture detailed sustainability data for all your products in one place.
- Bulk Updates: Save time by updating multiple articles simultaneously with environmental and material specifications.
- Real-Time API Feedback: Ensure your data meets API requirements with built-in error logging.
Why Choose Our Tool?
- No-Code Solution: Designed for users without programming or API knowledge.
- Fully Customizable: Adapt the macro to your unique business needs, ensuring seamless integration with your existing processes.
- Sustainability Support: Address growing demands for transparency and environmental responsibility with detailed, accurate data.
- Out of the box functionality: Working directly as soon as you provide the username and password with GoodOwnerCode (created through your Ongoing WMS Administrator)
Whether you’re managing environmental certifications, updating energy usage, or tracking recyclable materials for your products or packaging, our macro tool simplifies complex data management tasks while enhancing efficiency and accuracy.
Example of fields that can be populated through this integration

Note: dummy data is provided above for visualization of the solution. Materials and various inputs can be customized to your specific needs. Multiple certification input is possible with certain limitations.
Enhance Sustainability and Efficiency Today! Contact us to customize this macro tool to your specific Ongoing WMS setup and start making a measurable impact on your data management processes. Macro provided in the package below updates up to 10 materials and is live.
Pre-requisites: You will need an Ongoing WMS SOAP API Goodsowner Code for the macro to publish data to the system. Macro is using article number for identification of SKUs to update but can be adjusted to SKU ID.
Legal note: Apnum AB is not affiliated, not sponsored or in any way associated with Ongoing WMS, Ongoing Warehouse AB or any affiliated companies to the brand or legal entity. Ongoing Warehouse AB are not responsible or in any way related to the service quality provided by the macro or integrations with such – Apnum AB is responsible for the functionality and accuracy of SKU file updating towards SOAP API. End-user is responsible for testing the macro before processing bulk uploads. Refer to the VBA code and error logging in the file for user acceptance testing. Feel free to contact us for any assistance of further customized development or money-back guarantee related to macro functionality.
Keywords:
- Ongoing WMS Environmental Data
- Sustainability functionality in Warehouse Management
- Excel Macro for Environmental Reporting
- Recycled Material Data Management
- Warehouse Automation for Green Data Management
- Ongoing SOAP API integration