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.

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:

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.

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)}"
         }
      ]
   }
}