# Mark as paid orders from the excel sheet

**URL:** <https://community.parabola.io/t/mark-as-paid-orders-from-the-excel-sheet/1175>\
**Category:** Ask a question\
**Created:** [October 14, 2020, 12:20pm UTC](https://community.parabola.io/t/mark-as-paid-orders-from-the-excel-sheet/1175 "2020-10-14T12:20:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Povilas](https://avatars.discourse-cdn.com/v4/letter/p/4491bb/32.png) [@Povilas](https://community.parabola.io/u/Povilas)\
**Post date:** [October 14, 2020, 12:20pm UTC](https://community.parabola.io/t/mark-as-paid-orders-from-the-excel-sheet/1175/1 "2020-10-14T12:20:29Z")

</div>

Hi all,

I have a lot of COD orders and when I get a report what orders have been paid I need to manually mark as paid orders in my Shopify store.

How can I create a flow which would automatically mark as paid the orders from that excel sheet report?

If you have any ideas, please let me know.

Thank,  
Povilas

---

<div class="post-metadata">

**Author:** ![anon36387498](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@anon36387498](https://community.parabola.io/u/anon36387498)\
**Post date:** [October 15, 2020, 12:04am UTC](https://community.parabola.io/t/mark-as-paid-orders-from-the-excel-sheet/1175/3 "2020-10-15T00:04:51Z")

</div>

Hi @Povilas,

I think I have an idea of what this flow would look like:

 ![Screen Shot 2020-10-14 at 4.33.05 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/245909cb413fa8d69eba532b06335e789e0b7625.jpeg)  
  

- First, you’ll want to use the import step `Use Excel file` to upload the file with order payment information.

- Then you’ll want to use the import step `Pull from Shopify` to pull in your orders. Depending on what product information is in your excel file (line items versus orders), you’ll want to specify this in the `Pull from Shopify` step.  

- After these imports, you’ll use the step `Combine tables` to join the two datasets based on a column that exists in both datasets.  
  

The last part of the flow will require a bit more work. You’ll end the flow with the step `Send to an API`. Follow the steps 1-3 seen here to get the credentials set up:

> [@Add new products to shopify from CSV](https://community.parabola.io/t/add-new-products-to-shopify-from-csv/1156/6):
>
> @Massimo_Coppola good news! Confirmed that it’s possible to create new products with the step [Send to an API](https://parabola.io/destinations/api-export). 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: 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 In the Shopify Private apps page, click on the new app you made to pull up thos…

Once you have your URL from the credentials page, modify it to end in `/admin/api/2020-10/orders/{Id}/transactions.json`. If you originally pulled in your Shopify orders with line items detail, then change {Id} to {Order: Id}.

In the Body section of this `Send to an API` step, put this:

```auto
{
  "transaction": {
    "currency": "USD",
    "amount": "{your amount column here}",
    "kind": "sale",
  }
}

```

In the above example, the currency is set to USD, so adjust as needed. The amount field needs to reference a column, so replace what is inside the curly braces with the name of your column. The kind section is set to sale since it seemed most applicable to your use case. You can see other kind options in the **transaction properties** table here: [Transaction - REST](https://shopify.dev/docs/admin-api/rest/reference/orders/transaction#create-2020-10)