Dashboard

Sources

Import/connect data

Transactions

Wallets/Banks

Your wallets & banks

Return to homepage

Current lowest price at which a seller is willing to sell an asset

Total volume available at the lowest ask price

Bank Alias

Current highest price that a buyer is willing to pay for an asset

Total volume available at the highest bid price

Indicates whether the asset can be redeemed

The difference between the current price and the previous close price

Cumulative real-time rewards in my currency

The weighted average price of an asset across multiple major spot market exchanges, serving as a stable reference point for derivatives trading.

The percentage change between the current price and the previous close price

The closing price of the previous trading day

Indicates whether the trade was a taker (market order) or maker (limit order)

The annual percentage rate for a specific tier

The time interval for the data (e.g., 1m, 1h, 1d)

Order or trade type (e.g., limit, market)

Volume Weighted Average Price of an asset over a specified period

The percentage rate for airdrop rewards distributed yesterday

Retrieve open, high, low, close, and volume data

OHLCV Data

Order Book

Retrieve the 24-hour price ticker for a symbol

Ticker 24h

Trades

Retrieve a snapshot of my futures account

My Futures Account Snapshot

My Margin Account Snapshot

My Spot Account Snapshot

Retrieve my account asset dividend record

My Asset Dividend Record

Retrieve asset dividend records of my account

Asset Dividends

My Balances

My Deposit History

My Fiat Payments

My Fiat Transactions

My Flexible Position

My Flexible Positions

My Locked Positions

My Orders

Query sub-account transfer history (for main account)

My Sub-Account Transfers

My Trades

My Withdrawal History

# Lila Studio, chapter 4: launch weekend

The winter collection goes live Saturday. Léa has the products ([chapter 3](/blog/8-create-woocommerce-products-from-excel)), the stock ([chapter 2](/blog/7-bulk-update-woocommerce-stock-quantities-from-excel)), and for the first time, the nerve to actually *push* a launch.

A launch needs offers. Not one — several:

- a public code for the newsletter: 10% off the weekend.
- a little welcome discount for first-time buyers.
- and the ambitious one — a unique code for each of the thirty micro-influencers she's sending a scarf to, so she can see whose audience actually shows up.

Thirty-two coupons, give or take. In the WooCommerce admin that's thirty-two trips through the "Add coupon" form, each with a code, a type, an amount, an expiry. By Thursday night she'd hate the collection. She knows there's a better way now — because by chapter four, the better way is just *the* way.

## What a coupon is made of

A coupon is a code a customer types at checkout. A handful of fields define it:

- **code** — what they type, e.g. `WINTER10`.
- **discount_type** — `percent`, `fixed_cart`, or `fixed_product`.
- **amount** — the value: `10` means 10% on a percent code, or 10 in her currency on a fixed one.
- **date_expires** — when it stops working (Sunday midnight, for the weekend code).
- **usage_limit** — how many times it can be redeemed.
- **minimum_amount** / **maximum_amount** — cart bounds.
- **individual_use** — whether it can stack with other codes.

## Look before you leap

Old habit, good habit: before creating, she loads what's already there so she doesn't reuse a code by accident. `WooCommerce` → `Coupons` → **Load**.

![Léa's existing coupons, loaded before she adds the launch offers](https://apps-assets.pages.dev/v1/images/front/blog/woocommerce/coupons.png)

One tidy table — codes, types, amounts, expiries, how often each was used. She scans it, confirms `WINTER10` is free, and moves on. (That read-then-write rhythm is the same one she's had since [chapter 1](/blog/6-discover-what-you-can-read-from-woocommerce-in-excel).)

## The wall of coupons

She switches the panel to **Create**, keeps `Coupons`, and clicks **Load template**. Blank grid, coupon fields as columns. And now the spreadsheet does the thing spreadsheets are *for*.

The two simple ones she just types:

```text
code: WINTER10   | discount_type: percent     | amount: 10 | date_expires: 2026-12-07 | usage_limit: 1000
code: WELCOME5   | discount_type: fixed_cart  | amount: 5  | minimum_amount: 35       | individual_use: true
```

`WINTER10` — 10% off, dies Sunday night, capped so a screenshot leak can't drain it. `WELCOME5` — €5 off a €35 cart, and `individual_use` so it won't stack on top of the weekend code.

Then the influencers. Thirty unique codes would be a nightmare by hand — but it's a column, and columns are easy. She drops her list of thirty names beside the grid, builds `LILA-` + each name with a formula, fills the type and amount down all thirty rows in one drag, and just like that she has thirty distinct codes she can track individually.

```text
code: LILA-MAYA   | discount_type: percent | amount: 15 | usage_limit: 50
code: LILA-NOAH   | discount_type: percent | amount: 15 | usage_limit: 50
code: LILA-INES   | discount_type: percent | amount: 15 | usage_limit: 50
...
```

Thirty-two coupons, sitting in rows, none of them live yet.

## One publish

She clicks **Publish**. Every row becomes a real coupon in WooCommerce, in a single batch, and the familiar **Changes published.** confirms it. She reloads `Coupons` and there they all are — `WINTER10`, `WELCOME5`, and the thirty `LILA-` codes — ready to paste into a newsletter and thirty DMs.

If a code had clashed or a field been missing, the change log would have flagged that exact row and left the rest. It didn't. The whole campaign existed in the time it takes to write one coupon by hand.

Next Monday, she'll do the thing she couldn't do before: load `Coupons`, sort by usage count, and *see whose code actually sold*. Maya brought twelve orders; half the list brought none. That's not a guess anymore — it's a column.

## The same trick, in Excel, forever

None of this needed the web app. Léa built the influencer wall in Excel — names, a formula, a drag — and published from the same panel. A campaign that would be a slog in the admin became a column she filled once. The next sale, she'll duplicate the sheet, change the codes, and publish. That's the whole job.

## Four chapters later

Look back at Léa's week. She started buried under eleven browser tabs, unable to even *see* her shop. By Saturday she can:

- **read** anything in the store — products, orders, customers, sales — in one table;
- **fix** stock for a whole delivery in the time of one coffee;
- **create** an entire collection from a supplier file;
- **launch** with a wall of offers built in a single column.

Same shop, same spreadsheet she always loved — now wired straight to WooCommerce, every change published in batches over the REST API. No CSV round-trips. No import plugins. No eleven tabs.

Lila Studio's winter collection drops Saturday. Léa, for once, is going to watch it happen with her coffee still warm.

*Thanks for following the story. If you run a WooCommerce shop, the easiest place to start is exactly where Léa did — chapter 1, reading your store.*

## Useful links

- LinkyFlow for WooCommerce: [/products/woocommerce](/products/woocommerce)
- Customers & coupons doc: [/docs/woocommerce-customers-coupons](/docs/woocommerce-customers-coupons)
- Sales dashboard doc: [/docs/woocommerce-sales-dashboard](/docs/woocommerce-sales-dashboard)
- Start the story: [chapter 1 — reading your shop](/blog/6-discover-what-you-can-read-from-woocommerce-in-excel)


The finale of Léa's WooCommerce story: the winter collection drops Saturday, and she needs offers — a public code, a welcome discount, a wall of unique influencer codes. She builds them all in a spreadsheet column and publishes in one batch.

Lila Studio, chapter 4: launch weekend, and a wall of coupons in one column

# Lila Studio, chapter 3: the new collection

It's the spreadsheet that starts it.

A supplier Léa likes sends over a winter range — twenty pieces: a heavier hoodie, a ribbed beanie, a scarf she's a little in love with. It arrives, as these things always do, as an Excel file. Names in one column, wholesale prices in another, her own retail prices pencilled in beside them.

Twenty products. In the old world, that's twenty trips through the admin's "Add product" screen: type the name, set the price, pick a status, save, start again. An afternoon, easily. And she's been burned by the other route too — exporting a CSV template, reshaping her file to match its columns, feeding it to an importer, and decoding whatever it complained about.

But after [the delivery](/blog/7-bulk-update-woocommerce-stock-quantities-from-excel), she has a hunch. If she could *edit* sixty products in rows… could she *create* twenty the same way?

## From reading to writing a blank page

So far she's loaded existing things. Creating is the mirror image: instead of pulling data down, she asks LinkyFlow for an **empty template** shaped like a product, fills it, and pushes it up.

She flips the panel into **Create** mode. The left side now reads **Create**, and the button she's used all week — Load — becomes **Load template**.

- **Provider** → `WooCommerce`
- **Query** → `Products`
- **Load template**

Up comes a blank grid, the product fields as columns, waiting. For a clothing line, the ones that matter are the obvious ones:

- **name** — what the customer sees (the only truly required field).
- **regular_price** — her retail price.
- **sale_price** — optional, for later.
- **sku** — her own code.
- **status** — `publish` to go live, or `draft` to stage it quietly.
- **manage_stock** + **stock_quantity** — turn on counting and set the opening number.
- **type** — leave it blank and it's a `simple` product, which is what every piece in this range is.

## One row, one product

This is the moment the afternoon collapses into minutes. Her supplier's file is *already a table*. Names down one column, prices down the next — the exact shape the template wants. She lines them up and fills the rows: the winter hoodie, the ribbed beanie, the scarf, each on its own line, each with a price and an opening stock count.

![The winter collection taking shape in the create template](https://apps-assets.pages.dev/v1/images/front/blog/woocommerce/create-product.png)

The **Changes** panel logs every new value as a pending change, and the table badge reads **MODIFIED** — nothing has left her laptop yet. The **Inspector** on the right confirms what each field is as she clicks across. She sets the whole range to `draft`, because she wants to eyeball it before customers do, and because typing a `stock_quantity` quietly turns stock management on for each one — same trick as the delivery.

## Publish, and the collection exists

She clicks **Publish**. Every filled row becomes a real product in WooCommerce, in one batch, and the new pieces come back into the sheet — now with the IDs WooCommerce just assigned them. The **Changes published.** toast again.

If she'd left a name blank or fat-fingered a price, the Changes panel would have pointed at that one row and created the rest anyway. She didn't, this time. Twenty products, drafted, in the time it used to take to add three.

Later, when she's happy, flipping them from `draft` to `publish` is just another edit — load the range, change the status column, publish. The window-display moment is hers to choose.

## The part she'll repeat forever

And here's why this sticks: the source was a spreadsheet, and so was the work. Next season's range will arrive the same way, and Léa won't open the admin at all. She'll paste the supplier's file into the template — maybe build her SKUs with a formula, maybe fan a category down a column — and publish. Paste, publish, collection live.

## When the catalog grows up

The same create pattern covers the rest of the catalog as she needs it — each its own query:

- **Variations** — when a piece comes in several sizes or colours, create them under a parent product.
- **Categories**, **Tags**, **Brands** — set up the shelves she'll sort the new range onto.
- **Attributes** and their terms — define "Colour" or "Size" once, reuse everywhere.

Léa now reads her shop, fixes her shop, and grows her shop — all from the same table. Which leaves exactly one thing she's never done well: *selling hard*. The winter range is drafted. Launch weekend is coming. And a launch needs offers.

## Useful links

- LinkyFlow for WooCommerce: [/products/woocommerce](/products/woocommerce)
- Catalog & pricing doc: [/docs/woocommerce-catalog-pricing](/docs/woocommerce-catalog-pricing)
- Inventory & stock doc: [/docs/woocommerce-inventory-stock](/docs/woocommerce-inventory-stock)
- WooCommerce installation guide: [/docs/woocommerce-installation](/docs/woocommerce-installation)


Chapter 3 of Léa's WooCommerce story: a supplier sends a winter range as a spreadsheet, and instead of keying twenty products into the admin one by one, she fills a template and publishes the whole collection in a single batch.

Lila Studio, chapter 3: the new collection, born in a spreadsheet

# Lila Studio, chapter 2: the delivery

The van comes at 8 a.m. Sixty boxes of restock: beanies, the new charcoal hoodies, three sizes of the logo tee. Léa signs for it, drags the pallet into the spare room that is still, technically, her bedroom, and faces the part of the day she dreads.

Because right now her shop is *lying*. The website says "out of stock" on half these items. Customers who wanted the charcoal hoodie last week gave up. Until the numbers in WooCommerce match the boxes on her floor, every one of these is a sale she's quietly turning away.

In [chapter 1](/blog/6-discover-what-you-can-read-from-woocommerce-in-excel) she learned to *see* her shop in one table. Today she finds out if she can *fix* it from there — before her first coffee goes cold.

The old way was brutal: open the admin, find a product, edit, save, find the next product, edit, save. Sixty times. She'd done it before. It ate a morning and she always mistyped at least one.

## How WooCommerce stock actually thinks

Before she touches anything, one thing is worth knowing, because it's where people lose an afternoon. WooCommerce only tracks a *number* when **stock management is on** for that product. Three fields are in play:

- **Manage Stock** — whether WooCommerce counts units at all.
- **Stock Quantity** — the actual number on hand (only honoured when Manage Stock is on).
- **Stock Status** — in stock / out of stock / on backorder.

The kind part: when Léa types a quantity, stock management switches on by itself — exactly like the admin. So she doesn't have to think about it. She just types the count.

## She loads only what the van brought

She doesn't want all 24 products — she wants the ones on her floor. So she loads `Products` and adds a filter, by category, so the table holds just the restocked lines. Fewer rows, fewer ways to slip.

![The restocked products, loaded and ready to edit](https://apps-assets.pages.dev/v1/images/front/blog/woocommerce/catalog-products.png)

## One click turns the table into a worksheet

She hits **Edit**. The table wakes up. Two panels slide in on the right:

- **Changes** keeps a running list of every cell she touches — the old value, the new value. It's a receipt of exactly what she's about to do.
- **Inspector** tells her about the cell she's on: what type it is, and whether it's even allowed to change.

The editable cells light up. `stock_quantity` is a plain number. `stock_status` is a short menu — in stock, out of stock, on backorder.

Now the boxes. She works down the column the way anyone with a clipboard would: charcoal hoodie, 40. Logo tee S, 25. Beanie, 60. She's not clicking into anything — she's just filling a column, the way she'd tally an inventory on paper. Where she has a count sheet from the supplier, she pastes the whole column at once.

Every number she types lands in the **Changes** panel as a *before → after* line. For the first time, she can see the entire morning's work as a list and check it *before* anything goes live.

![Editing stock in rows, with every change tracked and then published](https://apps-assets.pages.dev/v1/images/front/blog/woocommerce/stock-edit.png)

A couple of items she doesn't have an exact count for — a few odd caps she'll deal with later. For those she doesn't touch the number; she just flips **Stock Status** to *in stock* so they stop showing as sold out. (Sold out for real? `outofstock`. Coming next week as a pre-order? `onbackorder`.)

## The moment of truth

She reads down the Changes panel one last time — it's her diff, her safety net — and clicks **Publish**.

Every pending change goes to WooCommerce in a single batch. A green **Changes published.** confirms it. She refreshes the table and the new quantities are sitting there. The website is no longer lying. The charcoal hoodie is buyable again.

Total time: the length of one coffee, still warm.

If a line had been rejected — a typo'd value, say — the Changes panel would have flagged *that* row and left the rest alone. She'd fix the one cell and publish again. No all-or-nothing.

## Why she'll do this in Excel next time

Here's the thing that actually changes Léa's life: her supplier sends the restock as a spreadsheet. Next delivery, she won't retype anything. She'll load `Products` into Excel, paste the supplier's count column straight onto her `stock_quantity` column, and publish from the same panel. The whole "export a CSV, remap the columns, fight the importer" ritual just disappears.

Read the shop, edit the shop, push it back — and the spreadsheet she already uses for everything is the cockpit.

## What she takes away

- Filter *before* loading, so you only edit what you mean to.
- The Changes panel is your receipt — read it before publishing.
- Type a quantity for real counts; use Stock Status for quick "back on the shelf" flips.
- Big restock? Publish in sensible batches rather than the whole store at once.

The shop is honest again, the boxes are unpacked, and Lila Studio is selling more than it did yesterday — same products, just true numbers.

Which gives Léa a dangerous idea. If updating sixty products took one coffee… how hard could it be to *add* a whole new collection?

## Useful links

- LinkyFlow for WooCommerce: [/products/woocommerce](/products/woocommerce)
- Inventory & stock doc: [/docs/woocommerce-inventory-stock](/docs/woocommerce-inventory-stock)
- Catalog & pricing doc: [/docs/woocommerce-catalog-pricing](/docs/woocommerce-catalog-pricing)
- WooCommerce installation guide: [/docs/woocommerce-installation](/docs/woocommerce-installation)


Chapter 2 of Léa's WooCommerce story: a pallet arrives, the shop is paused, and she has sixty stock quantities to fix before she can flip it back on — so she does it in rows, in one batch, instead of one product at a time.

Lila Studio, chapter 2: the delivery, and sixty stock counts before reopening

# Lila Studio, chapter 1: the morning Léa saw her whole shop at once

Léa opened Lila Studio out of her spare room. It started as a few logo beanies she printed for friends, and somehow turned into a real WooCommerce shop: tees, hoodies, caps, a "Logo Collection" she's quietly proud of. Orders now arrive while she sleeps.

The problem isn't sales. It's mornings.

Every day starts the same way. She opens her store admin, clicks **Products** to check what's running low. Opens a new tab for **Orders** to see what came in overnight. Another tab for **Customers** to recognise a repeat buyer. A reports page somewhere for yesterday's revenue. By 9:15 she has eleven tabs open and still doesn't have the one thing she wants: *a single view of her shop.*

This is the story of how Léa got that view — and then learned to run the whole shop from it. Four chapters:

1. **Seeing the shop (you're here)** — everything she can read.
2. [The delivery](/blog/7-bulk-update-woocommerce-stock-quantities-from-excel) — updating stock the day a pallet arrives.
3. [The new collection](/blog/8-create-woocommerce-products-from-excel) — adding products without touching the admin.
4. [Launch weekend](/blog/9-create-woocommerce-coupons-and-offers-from-excel) — building a wall of coupons in one column.

## The first table

A friend tells her about LinkyFlow — a way to talk to WooCommerce from a spreadsheet. She's skeptical (she's seen "Excel integrations" before), but it takes about a minute. She picks a **Provider**, picks what she wants to look at, clicks **Load**, and her catalog appears as a clean table.

- **Provider** → `WooCommerce`
- **Query** → `Products`
- **Load**

![Léa's Lila Studio catalog loaded as a single table](https://apps-assets.pages.dev/v1/images/front/blog/woocommerce/catalog-products.png)

There it is. Every product — the Beanie with Logo, the T-Shirt with Logo, the hoodies — with its price, its SKU, and crucially its **stock quantity** and **stock status**, all on one screen. No clicking into each product. 24 rows, the whole shop, in front of her.

On the left she notices the controls she'll come to live in: her connection (it filled in automatically — she only has one store), a **pagination** setting, an **Add filter** button, and a list of the columns she wants to see. She can drop the ones she doesn't care about before loading. Simple.

> And — this is the part that makes her laugh — the exact same panel runs **inside Excel**. The screenshots in this story are from the web app, but Léa does most of this in a spreadsheet, because that's where her formulas and her brain already live. Same three moves: WooCommerce → Products → Load, and the rows land in a worksheet.

## Everything is just another query

Once she gets it, she can't stop. Each thing she used to open a tab for is just a query she loads into the same kind of table.

Her **catalog** is more than a product list — categories, tags, brands, variations (the per-size versions of her hoodies), attributes like colour and size, even the reviews customers leave.

![Lila Studio's product categories in one view](https://apps-assets.pages.dev/v1/images/front/blog/woocommerce/categories.png)

The **sales side** is where she lingers. Orders, with number, status, total, payment method, and who bought what.

![Last night's orders, loaded in seconds](https://apps-assets.pages.dev/v1/images/front/blog/woocommerce/orders.png)

And the **customers** behind them — email, how many orders they've placed, how much they've spent. (By default it shows shoppers, not admin accounts, which is exactly what she wanted.)

![The people who actually buy from Lila Studio](https://apps-assets.pages.dev/v1/images/front/blog/woocommerce/customers.png)

Then the numbers she used to hunt for in a plugin — a **sales report** for any date range: total sales, net revenue, orders, items sold, customers. One row that tells her how the shop is doing.

![Yesterday in one row: the Lila Studio sales report](https://apps-assets.pages.dev/v1/images/front/blog/woocommerce/sales-report.png)

There's more she pokes at over her coffee — coupons, top sellers, tax rates, shipping zones, payment gateways, even the store settings. All of it readable, all of it a table she can drop next to the formulas she already trusts. No CSV exports. No copy-paste.

## Loading only what matters

Her shop is small now, but she's thinking ahead. Two controls keep it sane when it grows:

- **Filters** — she can ask for *only* the products in one category, or *only* last week's orders, before loading.
- **Pagination** — one page at a time, or the whole catalog in a single fetch.

Load less, move faster. Her morning ritual just went from eleven tabs to one table.

## Nothing broke

Here's what Léa likes most about chapter one: she changed nothing. Reading is the safe half. She looked at her entire shop and her shop didn't even notice.

But a table you can only *read* is half a tool. The next morning, a delivery van pulls up to her door with sixty boxes — and she's about to find out whether this thing can actually *change* her shop, not just show it.

## Useful links

- LinkyFlow for WooCommerce: [/products/woocommerce](/products/woocommerce)
- WooCommerce installation guide: [/docs/woocommerce-installation](/docs/woocommerce-installation)
- Catalog & pricing doc: [/docs/woocommerce-catalog-pricing](/docs/woocommerce-catalog-pricing)
- Sales dashboard doc: [/docs/woocommerce-sales-dashboard](/docs/woocommerce-sales-dashboard)


Meet Léa, who runs a small WooCommerce boutique. Chapter 1 of a four-part story: the morning she stopped juggling fifteen browser tabs and pulled her entire store — products, orders, customers, sales — into one table.

Lila Studio, chapter 1: the morning Léa saw her whole shop at once

# Shopify bulk catalog setup from Excel with LinkyFlow

Shopify's current product model separates three things that used to be mixed together:

- product-level data
- product option structure
- sellable variants

That is why many imports fail on Shopify: the product exists, but the option names do not exist yet, so the variant payload has nothing valid to attach to.

This guide gives you a workflow that stays readable in Excel and matches how Shopify actually behaves today.

## The short answer

For a new catalog import, the safest order is:

1. Create the product with `productCreate`.
2. Make sure the option names exist on the product before you create variants.
3. Create the sellable variants with `productVariantsBulkCreate`.
4. Keep `productSet` for later. It is another way to do the same job, and we will cover it in a dedicated next article.

The important Shopify rules are:

- `productCreate` can define product options and option values, but it creates only the initial variant.
- `productOptionsCreate` adds missing option names or starter values on an existing product.
- `productVariantsBulkCreate` needs one value for every existing option on the product.
- If the option already exists on the product, `productVariantsBulkCreate` can link an existing value by name or create a new value by name.

In this article, the recommended Excel workflow is still three sheets because it is easier to review, easier to troubleshoot, and better suited to merchandising and operations teams.

To keep the guide concrete, we stay on one story from beginning to end: you are launching a mug store and you want to create your first mug product with two color variants, `Red` and `Green`.

## What you will get at the end

- A structured `Products` sheet for product-level data.
- A structured `ProductOptions` sheet to seed option names on each product.
- A structured `ProductVariants` sheet to create sellable variants with price, SKU, and other variant data.
- A repeatable import process you can reuse for future catalog launches.

## Prerequisites

Before starting, make sure you have:

- A Shopify admin account with product permissions.
- LinkyFlow Shopify connection installed on Shopify: <https://apps.shopify.com/shop-flow>
- LinkyFlow add-in installed in Excel using the one-click flow:
  - Shopify connection page (CTA): [/products/shopflow](/products/shopflow)
  - Installation doc: [/docs/shopflow-installation](/docs/shopflow-installation)

## Step 1 Build your workbook structure

Create one workbook with three sheets:

- `Products`
- `ProductOptions`
- `ProductVariants`

Why this structure works well:

- `Products` holds content, merchandising, and SEO fields that belong to the product itself.
- `ProductOptions` is where you make Shopify aware of the option name used by the mug product, which in this guide is `Color`.
- `ProductVariants` is where you create the actual sellable combinations with pricing, SKU, and inventory-related data.

Keep the workbook simple:

- One row in `Products` = one product.
- One row in `ProductOptions` = one option seed row for one product.
- One row in `ProductVariants` = one sellable variant.

## Step 2 Build the Products create template in LinkyFlow

In the LinkyFlow panel, switch from **Read** to **Write**.

Then select **Create Product** (`productCreate`).

Start with this baseline field set:

- `title`
- `handle`
- `descriptionHtml`
- `vendor`
- `productType`
- `status`
- `SEO > Title`
- `SEO > Description`

Then click **Load** to generate the Excel input table.

Why these fields matter:

- `title` is the customer-facing product name and is also used by Shopify as a fallback when generating a handle.
- `handle` gives you a predictable URL slug. It is better to control it yourself than to let Shopify guess.
- `descriptionHtml` lets you keep product pages readable with basic formatting.
- `vendor` and `productType` make filtering, reporting, and catalog cleanup easier later.
- `status` helps you control catalog readiness in the admin.
- `seo.title` and `seo.description` improve search snippet quality and keep your catalog launch more complete from day one.

![Products create template with selected fields](https://apps-assets.pages.dev/v1/images/front/blog/product-creation/06392ec1.png)

## Step 3 Fill the Products sheet and run the create mutation

Fill each product row with complete and consistent information.

Example row:

- `title`: `Dawn Embrace Mug`
- `handle`: `dawn-embrace-mug`
- `descriptionHtml`: a clear product description with light HTML formatting
- `vendor`: `Sunrise Ceramics`
- `productType`: `Mug`
- `status`: `ACTIVE`
- `SEO > Title`: `Dawn Embrace Mug ceramic coffee mug`
- `SEO > Description`: `Ceramic coffee mug for daily use. Bulk managed from Excel with LinkyFlow.`

Click **Publish** in LinkyFlow to execute the mutation.

Important distinction:

- In LinkyFlow, **Publish** means “send the write request”.
- In Shopify, a product created with `productCreate` is still unpublished from sales channels by default.

So this step creates the product record in Shopify, but it does not automatically make the product visible on your storefront.

![Products sheet filled and ready to publish](https://apps-assets.pages.dev/v1/images/front/blog/product-creation/be7bc9d1.png)

## Step 4 Validate product creation and collect product IDs

After the write succeeds:

- Check LinkyFlow success notifications.
- Switch from **Write** back to **Read** if needed.
- Run a `products` read query and load at least:
  - `id`
  - `title`
  - `handle`

You will reuse `id` as `productId` in the option and variant steps.

![Products read query with id title handle](https://apps-assets.pages.dev/v1/images/front/blog/product-creation/abb47747.png)

## Step 5 Create option names before variants

This is the part that usually causes confusion.

Shopify does not let `productVariantsBulkCreate` invent option names on a product that has none yet. In our mug example, the product must already know that it has one option called `Color` before a variant can reference `Red` or `Green`.

Switch back to **Write** and select **Create Product Option** (`productOptionsCreate`).

In the template, keep only:

- `Product Id`
- `Name (Options)`
- `Name (Options > Values)`

Then click **Load**.

Recommended way to use this step:

- Create one row per option name that must exist on the product.
- Give each option one starter value.
- Do not try to enumerate every final variant combination here.

Examples:

```text
Product Id: gid://shopify/Product/...
Name (Options): Color
Name (Options > Values): Red
```

Why only a starter value is enough:

- The real goal of this step is to register the option name on the product.
- In our mug story, this means Shopify now knows that the product varies by `Color`.
- Once the option exists, `productVariantsBulkCreate` can later attach an existing value by name or create a new value by name.
- In practice, you can seed `Red` here, then create `Green` directly during the variants step.
- This keeps the `ProductOptions` sheet small and avoids duplicate option-name errors.

Practical advice:

- With the default `variantStrategy`, Shopify keeps the existing first variant.
- In this mug flow, once you seed `Color = Red`, treat `Red` as the variant that already exists.
- Do not create the same option name twice for the same product.
- If you already defined `productOptions` directly inside `productCreate`, you can skip this step.

Click **Publish**.

![Product Option template with one base value](https://apps-assets.pages.dev/v1/images/front/blog/product-creation/a2ed354e.png)

## Step 6 Build and fill the ProductVariants template

Switch to **Write** and select **Create Product Variant** (`productVariantsBulkCreate`).

Start with:

- `productId`
- `Variant > Option Values > Option Name`
- `Variant > Option Values > Name`
- `Variant > Price`
- `Variant > Compare At Price`
- `Variant > Inventory Item > SKU`
- `Variant > Taxable`

Then click **Load**.

![Product Variant create template](https://apps-assets.pages.dev/v1/images/front/blog/product-creation/81e8b6e0.png)

Rules to follow for each variant row:

- Set `productId` from Step 4.
- Provide one option value for every option that already exists on the product.
- Add commercial data such as `price`, optional `compareAtPrice`, and SKU.

Very important nuance:

- In this guide, the mug product has only one option: `Color`.
- That means each variant row stays simple: one option name and one option value.
- One row still equals one final variant the customer can buy.

For the mug product in this exact flow, the row to create is:

```text
Product Id: gid://shopify/Product/...
Variant > Option Values > Option Name: Color
Variant > Option Values > Name: Green
Variant > Price: 19.90
Variant > Inventory Item > SKU: MUG-DAWN-GREEN
```

Another important point:

- You do not have to preload every future option value in `productOptionsCreate`.
- In our example, `Red` is already present after Step 5, and `Green` is the variant you create during `productVariantsBulkCreate`.
- If the option exists on the product, Shopify can create a new option value during `productVariantsBulkCreate` when you send it by name.
- If you try to create `Red` again here, Shopify returns an error because that variant already exists.

Click **Publish**.

## Step 7 Decide whether to keep or replace the first variant

There are two coherent ways to work after `productCreate` or after seeding options:

1. Keep Shopify's first variant and create only the missing variants afterward.
2. Intentionally rebuild the full variant list with `productVariantsBulkCreate`.

This distinction matters because Shopify can preserve or remove the standalone first variant depending on the bulk-create strategy.

Practical recommendation for Excel imports:

- In this mug example, Shopify already keeps `Red` as the first valid variant, so Step 6 should create only the missing one, `Green`.
- If you want the variants sheet to be the single source of truth, use the appropriate bulk-create strategy and make sure the sheet contains the full final variant list for the mug.

The key point is consistency. Mixing both approaches is what usually creates duplicate or unexpected variants.

## Step 8 Final checks in Shopify admin

In Shopify admin:

1. Open **Products**.
2. Search for one of the created products.
3. Open the product detail page.
4. Confirm option names, variant list, prices, and SKUs.

Also verify:

- The option names on the product are exactly the ones your variants reference.
- The number of variants matches your spreadsheet.
- The first variant was either intentionally kept or intentionally replaced.

If you want the product to be visible to customers, run the publication step for the relevant sales channels after the catalog structure is finished.

![Created product shown in Shopify admin](https://apps-assets.pages.dev/v1/images/front/blog/product-creation/8e65b751.png)

## There is another way with `productSet`

Shopify also has `productSet`, and yes, it can be used to build the same mug in another way.

The difference is the mindset:

- in this article, you create the product step by step
- with `productSet`, you think more like a full synchronization of the product state

That approach is powerful, but it deserves its own article because the tradeoffs are different.

In the next blog, we will rebuild the same mug example, still with `Red` and `Green`, but this time with `productSet` so you can see when it is faster, when it is riskier, and why some teams prefer it.

## Common errors and fast fixes

- `PRODUCT_DOES_NOT_EXIST`:
  - `productId` is invalid or belongs to another store.

- `OPTION_VALUES_FOR_NUMBER_OF_UNKNOWN_OPTIONS`:
  - The variant row does not match the option structure on the product.
  - Check that every existing option on the product has one value in the variant input.

- `NEED_TO_ADD_OPTION_VALUES`:
  - The product still does not have the required option setup, or the variant input is incomplete.
  - Create or seed the missing option first, then retry the variants.

- duplicate option-name error on `productOptionsCreate`:
  - You are trying to create an option name that already exists on that product.
  - Create the option only once, then let variants create or reuse values.

- duplicate or unexpected first variant:
  - You mixed “keep the first variant” and “rebuild all variants” strategies.
  - Pick one strategy and make the sheet match it.

- `The variant 'Red' already exists. (variants.0)`:
  - `Red` was already kept as the existing first variant after the option step.
  - In this flow, send only the missing `Green` row in `productVariantsBulkCreate`.

- product exists in admin but is not visible on the storefront:
  - The write succeeded, but the product was not published to a sales channel.

- `NEGATIVE_PRICE_VALUE`:
  - Price must be greater than or equal to 0.

## SEO checklist for a new store

Before considering the import done, validate:

- `handle` is clean, readable, and unique.
- `seo.title` and `seo.description` are filled for the products that matter most.
- Titles, vendors, and product types are consistent across the catalog.
- The variant SKU pattern is consistent enough for support, warehousing, and future updates.

## Useful links

- LinkyFlow Shopify connection on Shopify App Store: <https://apps.shopify.com/shop-flow>
- One-click Shopify connection installation: [/docs/shopflow-installation](/docs/shopflow-installation)
- Shopify connection page: [/products/shopflow](/products/shopflow)
- Shopify `productCreate` docs: <https://shopify.dev/docs/api/admin-graphql/latest/mutations/productcreate>
- Shopify `productOptionsCreate` docs: <https://shopify.dev/docs/api/admin-graphql/latest/mutations/productoptionscreate>
- Shopify `productVariantsBulkCreate` docs: <https://shopify.dev/docs/api/admin-graphql/latest/mutations/productVariantsBulkCreate>


Step-by-step guide to create Shopify products in bulk from Excel with the correct Shopify order: create the product, define option names, then create variants, using one concrete mug example from start to finish.

Shopify bulk product import from Excel create products options and variants using LinkyFlow

Hi there!

In the fast-paced world of cryptocurrency trading, staying ahead of the game means having access to real-time data from multiple exchanges. Price discrepancies between exchanges can offer lucrative arbitrage opportunities, but only if you can identify and act on them quickly. Today, we'll explore how to use a SaaS tool to monitor prices across various exchanges and take advantage of these discrepancies.

## Understanding Arbitrage in Cryptocurrency Trading

Arbitrage involves buying an asset on one platform where the price is lower and selling it on another where the price is higher, thus making a profit from the difference. In cryptocurrency markets, where prices can vary significantly between exchanges, arbitrage opportunities are quite common. However, successfully executing arbitrage requires real-time data and quick action.

## Introducing the SaaS Tool for Crypto Price Monitoring

Our SaaS tool simplifies the process of tracking and comparing cryptocurrency prices across multiple exchanges. With just a few clicks, you can set up a dashboard to monitor a specific cryptocurrency symbol (e.g., BTC/USDT) across exchanges like Binance, Coinbase, and Upbit.

### Step-by-Step Guide to Setting Up Your Price Monitoring Dashboard

Let's walk through the process of setting up a page to display prices for one cryptocurrency symbol across different exchanges.

### Step 1: Select the Cryptocurrency Symbol

First, you'll need to select the cryptocurrency symbol you want to monitor. In our example, we'll use BTC/USDT. You can choose from other symbols like ETH/BTC or ETH/USDT if you prefer.

![Selecting the cryptocurrency symbol](https://apps-assets.pages.dev/v1/images/front/blog/arbitrage/select-crypto-btc-usdt.png)

### Step 2: Set the Limit of Records to Retrieve

Next, specify the limit on the number of records you want to retrieve. This limit determines how many ask and bid prices will be displayed from each exchange. For our example, we set the limit to 2.

### Step 3: Choose the Exchanges to Monitor

Select the exchanges you want to include in your comparison. Our tool supports numerous exchanges, including Binance, Upbit, and Coinbase. Simply click on the exchanges you want to add to your monitoring list.

![Selecting exchanges](https://apps-assets.pages.dev/v1/images/front/blog/arbitrage/select-crypto-exchange.png)

### Step 4: Construct the Dashboard

After selecting the symbol, limit, and exchanges, click the "Construct" button to build your dashboard. The tool will fetch real-time price data from the selected exchanges and display it in a tabular format.

### Step 5: Analyze the Data

Your dashboard will display a table with the latest ask and bid prices from each exchange. You can quickly spot price discrepancies that might present arbitrage opportunities. Here’s an example of what the data might look like:

![Example dashboard with price data](https://apps-assets.pages.dev/v1/images/front/blog/arbitrage/dashboard-crypto-exchang.png)

In this example, you can see the ask and bid prices for BTC/USDT from Binance, Upbit, and Coinbase. The comparison column shows the price differences between the exchanges, highlighting potential arbitrage opportunities.

## Taking Advantage of Price Discrepancies

Now that you have the data, it's time to act. Here's how you can leverage these price discrepancies for arbitrage:

1. **Identify the Opportunity**: Look for significant price differences between the ask price on one exchange and the bid price on another.
2. **Calculate Potential Profit**: Subtract the higher bid price from the lower ask price to determine your potential profit. Don’t forget to account for transaction fees and any withdrawal or deposit limits on the exchanges.
3. **Execute the Trade**: Buy the cryptocurrency on the exchange with the lower ask price and sell it on the exchange with the higher bid price. Ensure that you can complete both transactions quickly to lock in the price difference.
4. **Monitor and Repeat**: Keep an eye on your dashboard for new opportunities. The cryptocurrency market is volatile, and prices can change rapidly, so staying vigilant is key.

### Example Arbitrage Scenario

Let's walk through a hypothetical example based on the data from our dashboard.

* **Binance Ask Price**: $62,734.01 - **Upbit Bid Price**: $63,269.888

The price difference here is $63,269.888 - $62,734.01 = $535.878. If transaction fees and other costs are lower than this difference, executing this arbitrage trade could yield a profit.

## Tips for Successful Arbitrage Trading

1. **Stay Informed**: Keep yourself updated with the latest market trends and news that might affect cryptocurrency prices.
2. **Manage Risks**: Cryptocurrency trading is inherently risky. Only invest what you can afford to lose and consider using stop-loss orders to manage potential losses.
3. **Diversify**: Don’t put all your funds into one trade or one type of arbitrage. Diversifying your trades can help spread risk.
4. **Use Reliable Tools**: Ensure that the tools and platforms you use for trading are reliable and secure. Our SaaS tool provides real-time data, which is crucial for successful arbitrage.
5. **Be Quick**: Arbitrage opportunities can disappear quickly as other traders act on them. Speed is of the essence in this strategy.

## Conclusion

Leveraging price discrepancies across cryptocurrency exchanges like Binance, Coinbase, and Upbit can be a profitable strategy when executed correctly. Our SaaS tool provides the real-time data you need to identify these opportunities and act on them quickly. By following the steps outlined in this article, you can set up a powerful monitoring dashboard to help you stay ahead in the crypto trading game.

Happy trading!

This article explores how to use a SaaS tool to find price discrepancies across multiple cryptocurrency exchanges like Binance, Coinbase, and Upbit and leverage them for arbitrage opportunities.

How to Leverage Price Discrepancies Across Crypto Exchanges for Arbitrage Opportunities

Hi there!

Binance is one of the most popular cryptocurrency platforms in the world. If you're an active trader on Binance, you probably know how tedious it can be to keep track of all your transactions and maintain a record of your wallets. But don't worry, we're here to explain how you can display your Binance wallets and transactions directly in Excel for easier and more efficient tracking.

## Introducing... LinkyFlow! Connect wallets from the comfort of Excel

The first step to displaying your Binance wallets in Excel is to activate the "LinkyFlow - Bank & Crypto tools" plugin, which you can find on the Excel marketplace <https://appsource.microsoft.com/en-us/marketplace/apps?product=excel>

![Plugin linkyflow](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/untitled.png)

By clicking on Login, you can connect to LinkyFlow via a Google or Discord account, which allows you to connect Binance through the LinkyFlow platform, while ensuring the security of your access through these trusted third parties ;)

![Login popup with google and discord](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/untitled-1.png)

## How to Connect to Binance via Api Key?

Once connected, you will be presented with a screen on which to enter the API key and secret key. It is the equivalent of a Binance login/password that is specifically created so that an external application (here LinkyFlow) can connect to Binance.

It also allows you to restrict rights!! Here, we will start by creating a read-only key, which will not be able to perform any operations. In a future version, we will also be able to perform operations on our wallets from Excel :)

## Create a Binance key

To create the key, a Binance article describes how to do it: [](https://www.binance.com/fr/support/faq/comment-cr%C3%A9er-des-cl%C3%A9s-api-sur-binance-360002502072)[https://www.binance.com/fr/support/faq/comment-créer-des-clés-api-sur-binance-360002502072](https://www.binance.com/fr/support/faq/comment-cr%C3%A9er-des-cl%C3%A9s-api-sur-binance-360002502072)

In summary, you need to log in to your account <https://www.binance.com/fr/my/settings/api-management>, then navigate to "Api Management".

![Binance menu with gestion api](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/untitled-3.png)

Then "Create API" in the upper right corner.

![Bouton pour créer une api](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/untitled-4.png)

We have 2 choices: system-generated or self-generated, the simplest is to take the system-generated one.

![2 choix : généré par systeme ou auto généré](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/untitled-5.png)

We fill in the name and validate. Simple, isn't it?

The key is now created, with API Key and Secret Key. 2 important points:

* The secret key is your password, keep it aside and never share it with anyone
* Keep the API restrictions to "Allow Read". This limits access to read-only and **does not authorize operations on the account.** So no risk of unexpected transfers.

![Résultat de la génération de clé](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/untitled-6.png)

## Enter the key on the LinkyFlow add-in

In Excel, you now need to enter the API key and secret key.

* Binance API Key goes into "API Key"
* Binance Secret Key goes into "Secret Key"

Be careful not to paste spaces before/after :)

Then click on "Save".

![Add-in excel avec clé remplie](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/apikey-binance.png)

# Synchronize your Binance wallets & transactions

Now that the Binance key is saved, you can click on "Refresh". This operation will synchronize your Binance operations with Excel.

![Add-in synchronise les wallets et transactions Binance](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/dashboard-param.png)

The operation can take several minutes, this is due to Binance which greatly restricts calls to its platform and forces us to smooth out calls over time to avoid being blacklisted...

# Display my Binance wallets & transactions

Once the synchronization is complete, you can click on "Load".

This will retrieve my wallets and their balance on Binance and display them on Excel.

![Liste des wallets insérés dans excel](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/dashboard-filled.png)

I can also directly access Binance endpoints.

![My balances from binance endpoint](https://apps-assets.pages.dev/v1/images/front/blog/binance-excel/call-mybalance.png)

# Conclusion

By using LinkyFlow, it's easy to connect your Binance wallets to Excel for easier and more efficient tracking of your transactions. By following the simple steps outlined in this article, you can synchronize your Binance wallets and transactions directly in Excel, allowing you to better understand your investments and make more informed trading decisions. Don't hesitate to try this method to optimize your trading experience on Binance.

The article explains how to connect Binance wallets and transactions to Excel using "LinkyFlow - Bank & Crypto tools" for easier and more efficient tracking.

How to display wallets & transactions Binance directly from excel

# The role of cryptocurrencies in financial inclusion:

## 1)Impact of cryptocurrencies on financial inclusion and how they are being used to provide financial services to individuals and businesses in developing countries who may have limited access to traditional banking services

Cryptocurrencies are revolutionizing the financial industry and offering new possibilities for financial inclusion. In developing countries, where traditional banking services are often limited, cryptocurrencies have the potential to provide financial services to individuals and businesses who are otherwise excluded from the financial system. By using cryptocurrencies, people can make transactions at low costs and without the need for a traditional bank account. However, the adoption of cryptocurrencies in developing countries is not without its challenges, such as regulatory uncertainty and limited access to technology. We will explore the role of cryptocurrencies in financial inclusion, analyzing the opportunities and challenges they present. We will also examine the impact of cryptocurrencies on financial inclusion and the ways in which they are being used to provide financial services such as remittances, micropayments, and peer-to-peer lending. By understanding the potential of cryptocurrencies in promoting financial inclusion, we can identify ways to leverage this technology to benefit those who need it the most. Whether you're interested in cryptocurrencies or financial inclusion, this post has something for you. So, let's dive in and explore how cryptocurrencies can be a game-changer for financial inclusion in developing countries!

![An image of a group of people in a developing country receiving remittances via cryptocurrencies. This could illustrate how cryptocurrencies are being used to provide a low-cost and efficient alternative to traditional remittance services.](https://apps-assets.pages.dev/v1/images/front/blog/crypto-inclusion/dall-e-2023-02-16-08-09.png)

## 2) The Need for Financial Inclusion in Developing Countries

The need for financial inclusion is a global issue, and it is especially important in developing countries. According to the World Bank, more than half of the world's unbanked population lives in Asia, while Sub-Saharan Africa has the lowest financial inclusion rates globally. In many developing countries, traditional banking services are often limited, and people face significant challenges in accessing financial services, such as high fees and lack of infrastructure. This limits their ability to save, invest, and participate in the formal economy. By promoting financial inclusion in these regions, we can help people access formal financial services, which can have a transformative effect on their lives, and also promote economic growth and reduce poverty. Cryptocurrencies have emerged as a potential solution to the problem of financial exclusion in these regions, and they offer new possibilities for financial inclusion that were previously unavailable.

## 3) Cryptocurrencies and Financial Inclusion: Opportunities and Challenge

Cryptocurrencies have the potential to offer several opportunities for financial inclusion in developing countries. Firstly, cryptocurrencies are decentralized, which means that they can be used without the need for a centralized authority, such as a bank. This makes them particularly attractive to those who have limited access to traditional banking services, and who are unable to open a bank account. Secondly, cryptocurrencies offer lower transaction costs compared to traditional banking services, which can be particularly beneficial for remittances and micropayments. Additionally, cryptocurrencies can facilitate access to credit and financial services, which can help people start and grow businesses, and improve their financial well-being. However, the adoption of cryptocurrencies in developing countries also presents several challenges. The lack of infrastructure and regulatory uncertainty can make it difficult for people to access and use cryptocurrencies, and the volatility of cryptocurrencies can also pose a risk to users. Therefore, it is crucial to examine the opportunities and challenges presented by cryptocurrencies in promoting financial inclusion in developing countries, and to identify ways to address the challenges that arise.

![an image of people connected all over the world](https://apps-assets.pages.dev/v1/images/front/blog/crypto-inclusion/dall-e-2023-02-16-08-19.png)

## 4  Use Cases of Cryptocurrencies in Providing Financial Services to the Unbanked

Cryptocurrencies are being used in a variety of ways to provide financial services to the unbanked and underbanked populations in developing countries. One of the most significant use cases of cryptocurrencies in financial inclusion is for cross-border remittances. Cryptocurrencies such as Bitcoin and Ripple can be used to send and receive remittances at a fraction of the cost of traditional remittance services. Another use case of cryptocurrencies is in peer-to-peer lending, which can help people access credit even if they do not have a credit history. Moreover, cryptocurrencies are being used to facilitate micropayments and to enable people to make purchases without the need for a traditional bank account. Additionally, cryptocurrencies are being used to create digital identities that can be used to access financial services, which can be particularly beneficial for people who do not have a government-issued ID. These are just a few examples of the use cases of cryptocurrencies in promoting financial inclusion in developing countries, and as the adoption of cryptocurrencies increases, we can expect to see more innovative use cases emerge.

## 5) Impact of Cryptocurrencies on Financial Inclusion: A Critical Analysis

The impact of cryptocurrencies on financial inclusion is a topic of ongoing debate, and it is essential to critically analyze the potential benefits and drawbacks of their use. On the one hand, cryptocurrencies offer new possibilities for financial inclusion, particularly in regions where traditional banking services are limited. They offer a fast, secure, and affordable way to access financial services, and they can help people start and grow businesses, invest in education, and improve their financial well-being. However, the adoption of cryptocurrencies in developing countries also presents several challenges. For example, the lack of regulatory frameworks and infrastructure can make it difficult for people to access and use cryptocurrencies, and the volatility of cryptocurrencies can pose a risk to users. Additionally, the use of cryptocurrencies in illicit activities such as money laundering and terrorism financing has raised concerns about their potential negative impact on the global financial system. Therefore, it is important to critically analyze the impact of cryptocurrencies on financial inclusion and to identify ways to address the challenges associated with their use.

## 6) Future of Cryptocurrencies in Financial Inclusion: Possibilities and Limitations

The future of cryptocurrencies in financial inclusion is promising, but there are also limitations that need to be considered. Cryptocurrencies have the potential to be a game-changer in promoting financial inclusion, particularly in regions where traditional banking services are limited. They offer a fast, secure, and affordable way to access financial services, and they can help people start and grow businesses, invest in education, and improve their financial well-being. As more people in developing countries gain access to smartphones and the internet, the potential for cryptocurrencies to expand their reach and impact will only continue to grow. However, there are also limitations that need to be considered. The lack of infrastructure, regulatory frameworks, and technical expertise can make it difficult for people to access and use cryptocurrencies, and the volatility of cryptocurrencies can pose a risk to users. Moreover, the need for reliable internet connectivity and the potential for digital divides may limit the impact of cryptocurrencies on financial inclusion in some regions. Despite these challenges, the possibilities for cryptocurrencies in promoting financial inclusion are significant, and we can expect to see continued innovation in this space in the coming years.


This blog article explores the impact of cryptocurrencies on financial inclusion and how they are being used to provide financial services to individuals and businesses in developing countries who may have limited access to traditional banking services. We analyze the opportunities and challenges presented by cryptocurrencies in promoting financial inclusion, such as lower transaction costs, access to credit, and digital identities. However, we also examine the risks associated with cryptocurrencies, including regulatory uncertainty and volatility. By understanding the potential and limitations of cryptocurrencies, we can identify ways to leverage this technology to benefit those who need it the most, promoting economic growth and reducing poverty in developing countries.

The Role of Cryptocurrencies in Financial Inclusion: Opportunities and Challenges

## So what is the liquidity ?

Companies need liquidity in order to pay their bills and meet their financial obligations. This includes paying employees, suppliers, rent, taxes, and other expenses. Without sufficient liquidity, a company may struggle to pay its bills on time, which can lead to financial problems and even bankruptcy.

Having sufficient liquidity is especially important for companies that operate in industries with a high level of uncertainty or volatility, as they may need to be able to access cash quickly in order to respond to changing market conditions or unexpected events. For example, a company that operates in the retail sector may need to have a high level of liquidity in order to be able to respond to changes in consumer demand or supply chain disruptions.

In addition to helping a company meet its financial obligations, liquidity can also help to improve investor confidence and support the value of a company's stock. Companies that have a high level of liquidity are generally seen as being financially healthy and stable, which can make them more attractive to investors.

Overall, having sufficient liquidity is essential for the smooth operation and financial health of a company. It allows a company to meet its financial obligations, respond to changing market conditions, and improve investor confidence, which can support the value of the company and its stock.

![Man wondering about money](https://apps-assets.pages.dev/v1/images/front/blog/9c6b2bb6.png)

## C﻿an we have liquidity as crypto ?

Yes, it is possible to have liquidity as a cryptocurrency or digital asset. In fact, liquidity is an important consideration for investors and traders in the cryptocurrency market, as it can affect the value and usability of a particular crypto-asset.

Crypto-asset liquidity refers to the ability to buy or sell a particular cryptocurrency or digital asset in a timely manner and at a reasonable price. A crypto-asset with good liquidity should be relatively easy to buy or sell, and the price should be stable. On the other hand, a crypto-asset with low liquidity may be more difficult to buy or sell, and the price may be more volatile.

There are several factors that can influence the liquidity of a particular crypto-asset, including the volume of trades being conducted on a particular exchange or platform, the number of exchanges or platforms that the asset is listed on, and the overall market demand for the asset. In general, crypto-assets with high liquidity are more attractive to investors and traders, as they are easier to buy and sell and have more stable prices.

Overall, liquidity is an important consideration for investors and traders in the cryptocurrency market, as it can impact the value and usability of a particular crypto-asset. Understanding the factors that influence liquidity can help investors make informed decisions about which crypto-assets to buy or sell, and how to manage their portfolios.

## I﻿s crypto a better liquidity asset than traditional money ?

The liquidity of traditional money (such as fiat currency) and cryptocurrency can vary depending on a number of factors. In general, traditional fiat currencies tend to have higher liquidity than cryptocurrencies, as they are more widely accepted and more stable in value.

One of the main factors that affects the liquidity of a particular asset is the volume of trades being conducted. Traditional fiat currencies, such as the US dollar or the euro, tend to have high liquidity due to the high volume of trades being conducted in these currencies. This is because they are widely accepted as a form of payment and are used in a large number of transactions around the world.

In contrast, many cryptocurrencies have relatively low liquidity compared to traditional fiat currencies. This is because they are not as widely accepted as a form of payment and tend to have a more volatile value. As a result, it may be more difficult to buy or sell certain cryptocurrencies, and the prices may be more volatile.

Another factor that can affect the liquidity of an asset is the number of exchanges or platforms that it is listed on. Traditional fiat currencies are typically listed on a large number of exchanges and platforms, which increases their liquidity. In contrast, many cryptocurrencies are only listed on a limited number of exchanges, which can lower their liquidity.

Overall, while both traditional fiat currencies and cryptocurrencies can have liquidity, traditional fiat currencies tend to have higher liquidity due to their wide acceptance and stable value. However, the liquidity of both types of assets can vary depending on a number of factors, and it is important to consider these factors when evaluating the liquidity of a particular asset.

![Men with traditional fiat money](https://apps-assets.pages.dev/v1/images/front/blog/893fc27f.png)

## Should we throw fiat currency and only use crypto ?

It is not necessarily advisable to throw out fiat currency and only use cryptocurrency. While cryptocurrencies have some unique features and benefits, they also have some limitations and risks that should be considered.

One of the main limitations of cryptocurrencies is that they are not widely accepted as a form of payment. While some merchants and online retailers do accept certain cryptocurrencies, most merchants and service providers still accept only traditional fiat currencies. This can make it difficult to use cryptocurrencies for everyday transactions and expenses.

Cryptocurrencies also tend to be more volatile in value compared to traditional fiat currencies. The value of a particular cryptocurrency can fluctuate significantly over a short period of time, which can make it difficult to predict and plan for. This can make it risky to use cryptocurrencies as a primary form of currency, as the value of your assets could potentially drop significantly in a short period of time.

In addition to these limitations, cryptocurrencies also carry other risks, such as the risk of cyber attacks, fraud, and loss of access to your assets. It is important to carefully consider these risks and limitations when deciding whether to use cryptocurrencies as a primary form of currency.

Overall, while cryptocurrencies have some unique features and benefits, it is not necessarily advisable to throw out fiat currency and only use cryptocurrency. It may be more practical to use a combination of both traditional fiat currency and cryptocurrency, depending on your specific needs and circumstances.

## C﻿onclusion

T﻿he best you can do is use a combination of fiat and crypto currency, but keep in mind that you must do your own research on the subject and consult an expert if necessary.


This article covers the concept of liquidity, its importance for companies, and how it applies to the cryptocurrency market. It also compares the liquidity of traditional fiat currency to cryptocurrencies and discusses the risks and limitations of using cryptocurrency as a primary form of currency.

Excel workflows for operators