topic Re: Netsuite to Shopware Updating products in Workato Pros Discussion Board

Netsuite to Shopware Updating products

Jamesbird — Fri, 21 Mar 2025 08:53:42 GMT

Hello Community,

Does anybody have experience with netsuite connected to shopware with updating products when updating netsuite data?

I use the HTTP connector to update shopware but also want to start using the shopware connector created by workato but still figuring that out.

We are using a lot of look up tables as we are using lists within Netsuite (internal ID) so we then need to connect the internal ID to the correct value and then select the correct shopware id to update shopware. Not sure if this is the best way to be working.

Kind regards,

James Bird

Re: Netsuite to Shopware Updating products

Prudvi — Sat, 22 Mar 2025 16:39:31 GMT

Hi @Jamesbird,
Instead of Lookup, if possible try creating a ExternalID in both Systems and use this ExternalID for searching the records and updating in Shopware.
This might increase your task consumption.
Regards,
Prudvi

Re: Netsuite to Shopware Updating products

Jamesbird — Thu, 27 Mar 2025 13:02:17 GMT

@Prudvi

But then we would have to create an externalID for all properties, categories and values that we have created in shopware? in order to use external IDs for every property, category, and value created in Shopware, you would need to create and maintain those IDs for each entity.

Re: Netsuite to Shopware Updating products

Prudvi — Thu, 27 Mar 2025 14:05:10 GMT

Hi @Jamesbird,
As you suggested you can try with Shopware connector as your last option or we can see if someone has previously worked and can help.
Regards,
Prudvi

Re: Netsuite to Shopware Updating products

Jamesbird — Fri, 28 Mar 2025 14:53:54 GMT

Hi @Prudvi,

I think i have found a solution a combination of adding shopware id's to netsuite and creating custom fields for propertys in shopware.

Because then i have a combination of sending values from netsuite to shopware without having to use shopware id's and list in netsuite i will add the shopware id to pick up the shopware id direct from netsuite