Tiny ERP icon

Tiny ERP

Interact with Tiny ERP API

Overview

This node integrates with the Tiny ERP system to manage product stock variations. Specifically, the Update Variation operation allows users to update details of a specific product variation within Tiny ERP. This is useful for scenarios where product variations (such as size, color, or other attributes) need to be updated with new pricing, stock levels, SKUs, or GTIN codes.

Practical examples include:

  • Updating the price or promotional price of a product variation.
  • Changing the SKU or GTIN barcode associated with a variation.
  • Adjusting initial stock quantities for a variation.

This operation helps maintain accurate and up-to-date product variation data in your ERP system, which is critical for inventory management, sales, and reporting.

Properties

Name Meaning
Product ID The unique identifier of the product to which the variation belongs.
Variation ID The unique identifier of the specific product variation to update.
Variation Data A collection of fields describing the variation's properties to update:
- GTIN: Variation GTIN barcode.
- Initial Stock: Initial stock quantity.
- Price: Variation price.
- Promotional Price: Variation promotional price.
- SKU: Variation SKU code.

Output

The output JSON contains either:

  • A success confirmation object indicating the product and variation IDs that were updated, e.g.:
{
  "success": true,
  "productId": 123,
  "variationId": 456
}
  • Or an error message if the update failed.

No binary data is output by this operation.

Dependencies

  • Requires an API authentication credential configured in n8n to connect to the Tiny ERP API.
  • The node uses HTTP requests to interact with Tiny ERP endpoints.
  • No additional external dependencies are required beyond the configured API credentials.

Troubleshooting

  • Common issues:

    • Invalid or missing Product ID or Variation ID will cause the API request to fail.
    • Providing invalid data types or unsupported fields in the variation data may result in errors.
    • Network or authentication failures can prevent successful updates.
  • Error messages:

    • "The operation "updateVariation" is not supported!" — indicates the operation parameter was incorrect or unsupported.
    • API errors returned from Tiny ERP will be passed through; check the error message for details such as invalid IDs or permission issues.
  • Resolutions:

    • Ensure all required IDs are correct and exist in Tiny ERP.
    • Validate input data types and required fields before execution.
    • Confirm API credentials are valid and have sufficient permissions.
    • Enable "Continue On Fail" in the node settings to handle errors gracefully during batch processing.

Links and References

Discussion