You can now have the possibility to automatically calculate a special number for each new created product.
(The special number can be used for many reason mainly for external system: product catalog number, product ranking number,...)
Configurations to make it work
- Create a new comfort variable: Organization > Season parameters > Custom variables
- Create a new external interface "Firehose Product" with type "ProdNum plugin": Organization > Tools > External Interface > List of Interfaces
- The Comfort Variable Code setup in the plugin has to be the same with the code defined earlier in Custom variable (e.g. "prodNum")
- Input value in the Counting Offset (the starting number which is updated incrementally by 1 for new found product)
- Sequence name is a technical ID that is generated by the system to support multiple ProdNum interfaces that are scheduled to run simultaneously:
- Each interface holds a unique Sequence Name upon running
- Sequence name provides counter separately for each interface running (e.g A product can have different product numbers provided by different interfaces)
- In order to reset the counter for an interface, simply clear the Sequence name, a new sequence name is generated on the next run and the counter starts again from Counting offset (note: you cannot input a new Counting offset with the existing Sequence name because it continues using the old Counter, please clear the Sequence name before running with the new Counting Offset)
- Create a batch to run automatically
How it works
- After creating a product successfully, it will automatically set a new Custom Variable with value calculated by the interface
- Which products are considered to be updated by the interface?
- Product which is created
- Product is updated
(If a product already has the "prodNum" Comfort Variable value, it is skipped by the interface) - If you need all existing products to be "force updated" by the batch, a migration script must be run on the DB.