Add new products to shopify from CSV

i’m trying toAdd new products to shopify from CSV
but having errors like this!

parabola|690x386

Hey @Massimo_Coppola - Looks like my teammate, Brian, just got back to your Intercom message. Based on your screenshot, it looks like you’re trying to add products to collections. Is that what you’re trying to do?

In the case, we need the Product ID field to be mapped to Product IDs that exist in Shopify. Based on your screenshot, it looks like you’re mapping Product ID to Variant SKU data which is what’s causing the error.

I’m trying to add NEW Products.
Product ID do not exist forn NEW Products.

Hi @Massimo_Coppola, unfortunately it isn’t possible to add new Shopify products through our Send to Shopify integration yet. Our Shopify steps support adding Product IDs of existing products to collections for automating organization and improving processes like inventory management.

We’ll note this as a potential addition to make for our Shopify integration. When you have time, can you add this as a feature request so others can vote on it to show their support?: https://community.parabola.io/c/feature-requests/

Let us know if there are any other questions we can assist you with on Community or at help@parabola.io.

1 Like

Hi’
Can you ask to developer if is possible to add new products sometimes to shopify
using a new flow like this ? :

origin of data is csv file > filter data > send to shopify using API ??

@Massimo_Coppola good news! Confirmed that it’s possible to create new products with the step Send to an API. First, you’ll need to customize the API Endpoint URL for your specific API key, secret, and store URL. Please see below for that process:

  1. Set up a Shopify private app using the following URL (replace the “your-url” with what your Shopify store base is):
    https://your-url.myshopify.com/admin/apps/private

  2. In the Shopify Private apps page, click on the new app you made to pull up those customized details.

  3. On that same page, update API Permissions to add Products with read and write permissions.





Then, return to Parabola and connect your flow to the export step Send to an API. Configure the step by:

  • In the Type section, select POST.
  • In the API Endpoint URL section, enter the Example URL from your Shopify private app details page and append “admin/api/2020-10/products.json” to the end of it.
  • In the Body section, enter the request seen in Shopify’s Create a new product guide.

Here’s what the step Send to an API should look like once you finish:

1 Like

I’m very happy for this news.

I Tried to do the steps you give to me.

but i have a 403 error when i run flow

See attached screenshot.

can you help me with this?

Hi @Massimo_Coppola,

Following up here after our email conversation – below is the step’s 403 error message:

{
  "errors": "[API] This action requires merchant approval for write_products scope."
}

This is letting us know that part of the set up for Shopify’s private app to generate the API key isn’t finished. It looks like your Shopify private app permissions needs “write_products” added. Please see step 3 from an above post response:




Once that permission is added in on your Shopify’s private app page (https://your-url.myshopify.com/admin/apps/private) and refresh this Send to an API step, the error should be resolved.

Read&Write Everywere

@Massimo_Coppola thanks for sending that screenshot over of your Shopify Private App > Admin API Permissions page. I noticed that a part of the Customer API “Clienti” is highlighted. Can you check to see if you have one called “Prodotto”, or another Italian word for product?

Shopify’s error message could be caused by two things. Either the permission settings aren’t right, or it has something to do with the API Endpoint URL. Usually if it is the latter, like an issue with the username and API key, the error message will mention an authentication error. Since the error message talks about merchant approval for writing to products, it likely has to do with the private app’s permission settings.

The highlighted items are not errors, only warnings , advise that giving read and write permission is dangerous for security.

Prodotto = Product
Clienti=Customers

yoyu have other customers using api with shopify? can we see how they make authentication?

Hello. i do not know if you done something on your side, but now is working.

the only issue is that only

“product”: {
“title”: “{Item}”,
“body_html”: “{Item}”,
“vendor”: “{Manufacturer}”,
“product_type”: “Sedie Gaming”,

pass to shopify.

“barcode”: “{EAN}”,
“weight”: “{Weight}”,
“inventory_quantity”: “{in stock (external)}”,
“price”: “{Price}”,
“sku”: “{SKU}”,

are not passed in shopify.

do you have any idea ???

Hi @Massimo_Coppola - Glad to hear the permissions are working for you now. Yes, we have many customers who use Parabola to connect to the Shopify API (in cases where our Shopify integrations don’t yet support a particular use case).

I took a look at the Products API docs from Shopify: https://shopify.dev/docs/admin-api/rest/reference/products/product

It looks like the reason why some of the fields didn’t get passed to Shopify successfully is because those are Product Variant fields.

We can help you figure out the best way to update the product variant information in Shopify as well. Will there only be one variant per product in your case?

Also, try using our Pull from Shopify step and pull in Product data with Variant detail. Let me know if you see any variant information for the new products you just created via the API.

1 Like

The other info i need to add are :

SKU
EAN
Price
Weight
Tags

How can be added?

Hey @Massimo_Coppola,

Just closing the loop on this as I know we’ve been communicating internally. Using the JSON body below should successfully create Shopify products using the above information:

{
   "product":{
      "title":"{Item}",
      "body_html":"<strong>{Item}</strong>",
      "vendor":"{Manufacturer}",
      "product_type":"{Category}",
      "tags":[
         "Computeruniverse",
         "{Manufacturer}",
         "{Category}"
      ],
      "variants":[
         {
            "price":"{Price_sell}",
            "cost":"{Price}",
            "sku":"{SKU}",
            "barcode":"{EAN}",
            "weight":"{Weight}",
            "available":"{in stock (external)}"
         }
      ]
   }
}
3 Likes

Yes, now the only issue is adding Stock quantity.

Hey @Massimo_Coppola,

You’ll need to send your inventory quantities to the inventory endpoint. Using the product variant endpoint won’t allow you to set the inventory levels.

After creating your products, you’ll need to get your Inventory Item Id and Location Id. The Pull from Shopify step will be able to grab those columns. They help tell Shopify which inventory item is being adjusted and the location of that inventory item.

Use the Send to Shopify step to adjust your inventory levels by inserting those columns along with your {in stock (external)} column to set the quantity.

I also sent a detailed walkthrough to your inbox. Hope that helps!

3 Likes

|### Massimo Coppola alexia.trading@gmail.com|11:53 (3 minuti fa)||

a Daniel, daniel

|

Hi Daniel.

I created a flow (i called the flow For Daniel in case you want to see)
as you described in your email .
When i run the flow report an error.

Can you help me?

Hi @Massimo_Coppola,

I replied to your email, but I wanted to close the loop on the community thread.

The reason for this error was likely caused by incorrect or missing data from your Parabola flow. When mapping your Parabola columns to Shopify’s fields, be sure the data type is accurate and correctly linked.

In your case, it looks like either the inventory_item_ id, the location_id, or the available_adjustment was missing.

Glad to hear you are now able to sucessfully run your flow!

1 Like