Netsuite to Shopware Updating products

[Jamesbird]

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 

[Prudvi]

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

[Jamesbird]

@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.

[Prudvi]

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

[Jamesbird]

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