Custom flow integration netsuite addresses to shopify addresses: multiple addresses mapping issues

[Giovani_Marianne]

Hello Celigo connective team,

Our client is currently having an issue for mapping netsuite company addresses into shopify company addresses. For example, the aim is to get all the netsuite addresses for a specific netsuite company and create it into shopify company with all the addresses related to that company. We manage to create 1 netsuite company into the same shopify company with only 1 address. How to do it for multiple addresses? I am using the template “Shopify B2B Netsuite”. I was modify only the flow “NetSuite company to Shopify company (Create/Update)” (to create 1 company) and “NetSuite locations to Shopify locations (Create/Update)“ (to add all the addresses). I have modified both the presavePage and the build variables json (response mapping) on both the company flow and location flow. However, on the location flow> import step “Create location“, i got the following error: Message:
could not extract id using path: data.companyLocationCreate.companyLocation.id from resource:

{
    "errors": [
        {
            "message": "Field 'companyLocationCreate' is missing required arguments: companyId",
            "locations": [
                {
                    "line": 3,
                    "column": 3
                }
            ],
            "path": [
                "mutation CompanyLocationCreate",
                "companyLocationCreate"
            ],
            "extensions": {
                "code": "missingRequiredArguments",
                "className": "Field",
                "name": "companyLocationCreate",
                "arguments": "companyId"
            }
        }
    ]
}

Code: missing_id

Source: Resource

[ellyxzerdavidjohn12 (Ellyxzer Feraer)]

@Giovani_Marianne

1 netsuite compa

Hi @Giovani_Marianne,

I’m unaware if this is feasible yet, but I can do a testing on my end. Can you verify if my understanding is correct:

1. You have an existing company on NetSuite with an existing address from Shopify

The goal is to add another Address to the Existing Company record via the NetSuite locations to the Shopify Location flow. Would this be correct? If yes, are you just adding a new location or address on Shopify Company to add the new address on NetSuite?

Thank you!

[Giovani_Marianne]

Hello,

Aim: Transferring netsuite multiple addresses into shopify multiple addresses for a specific company.

Kindly note in netsuite you can specify only one address to be shipping by default and only one address to be billing by default. I am assuming this is why shopify cannot create specific billing addresses.

Please see specific scenarios below:

netsuite :
ex. company1
ex. address1 (default shipping address yes and default billing address yes)
ex. address2 ( no default shipping address yes and no default billing address yes )
ex. address3 ( no default shipping address yes and no default billing address yes )

ex. address4 ( no default shipping address yes and no default billing address yes )

Shopify after my customization:
ex. company1
ex. location1=address1 > default shipping address1 & default billing address1 = OK
ex location2=address2 (shipping2 is populated correctly but billing address is the default billing address in address1)
ex location3=address3 (shipping3 is populated correctly but billing address is the default billing address in address1)

ex location4=address4 (shipping4 is populated correctly but billing address is the default billing address in address1)

My questions:

1. For different shipping and billing address to be created in shopify should we customize the address form and add new boolean fields ex. default billing and default shipping, so that we can specify this information to celigo so that celigo knows which is shipping and which is billing address?
2. Is it much easier to create a custom record that holds specific billing and shipping etc. But on a custom record we do not have the standard subtab, fields etail. So, it might be more complex to achieve.

To summarize the aim:

• For 1 specific company with multiple address shipping and billing in netsuite> create the same in shopify 1 company with multiple shipping and billing address.

Thankin you in advance for your help.

[Giovani_Marianne]

Hello,

Just for your information. We should use the custom record "localisation horizon" instead of customer table. This is a must for the client following a meeting with them yesterday. So, i am using the custom record. I manage to create the company and store the gid also. Now, what i am trying to do is creating multiple addresses into shopify for a specific company:

Also, the result is wrong because there should be only one company with different addresses:

This also I am trying to correct.

If you have any guidelines on these two issues please let me know. Also, i want the verification to be done on the field "Company", I want to use it to determine whether a company should be created or updated as well creating multiple addresses. For creating multiple addresses I am currently using and modifying the flow locations provided by the template Shopify B2B.

Thanking you in advance.

[mengdionisio]

Hi @Giovani_Marianne! Do you still need assistance on this issue? I checked our support tickets and found a similar issue that you raised and was resolved by you adding a script, but the records you mentioned from here are quite different. I just want to confirm if that resolved this issue as well. Thanks!

[Giovani_Marianne]

Hello Meng,

I managed to solve the issue. However, I would need more guidance on the following:

• I already have a custom flow working perfectly for scheduling but the client needs it to be real-time instead of schedule.
• So how to convert the custom flow from schedule to real-time, how easy it is? How much time it might take? Because I am still investigating how to convert a schedule flow to a real-time flow.
• I urgently need assistance on that point.

Thank you in advance.

[tylerlamparter]

Pretty easy, just add a new export where you listen for real time events as opposed to the scheduling of a saved search or api call. You'll need to remap your data to the new data structure if it's any different or you can add a transform on the listener export to match the same format you previously had.

[Giovani_Marianne]

Hello Tyler,

Ok noted. Thank you. I will try and get back to you if I need more details.