# Stock Upload (CSV)

### Sending the stock file via SFTP

To submit a stock file, the following endpoint is used and the stock file needs to be sent periodically to this endpoint:

`stfp {Merchant ID}@sftp.m-board.io`

{% hint style="info" %}
The **Merchant ID** (Username) and **API Key** (Password) is required to communicate with the stock importer. These credentials can be obtained from [support@michelberger.digital](https://email:support@michelberger.digital).
{% endhint %}

### Testing the connection

Use the instructions that follow to transfer files from the command line using OpenSSH.

1. On Linux or macOS, open a command terminal.
2. At the prompt, enter the following command: \
   `stfp {Merchant ID}@sftp.michelberger.digital`
3. (Optional) To view the user's home directory, enter the following command at the `sftp` prompt: \
   pwd
4. To upload a file from your file system to the server, use the `put` command. \
   For example, to upload `hello.txt` (assuming that file is in your current directory on your file system), run the following command at the `sftp` prompt: \
   `put hello.txt`<br>

   A message similar to the following appears, indicating that the file transfer is in progress, or complete: \
   `Uploading hello.txt to /my-bucket/home/sftp_user/hello.txt`

   `hello.txt 100% 127 0.1KB/s 00:00`

Detailed instructions how to transfer files using different clients (e.g. WinSCP, Cyberduck or FileZilla) can be found [here](https://docs.aws.amazon.com/transfer/latest/userguide/transfer-file.html).&#x20;

### Format

{% hint style="info" %}
Comma Separated Value (CSV)

* Must use semi-colons (`;`) as field separator
* Only allowed encodings are `UTF-8` and `UTF-16`
* String-formatted fields should be enclosed by double quotes
* **Filename conventions**:
  * Prefix `FULL` for daily full imports \
    e.g. `FULL_store1_2022-07-30T04:55:30.csv`
  * Prefix `DELTA` for hourly delta imports \
    e.g. `DELTA_store1_2022-07-30T17:30:30.csv`
    {% endhint %}

### Stock file columns

<table><thead><tr><th width="287.3333333333333">Column</th><th width="150">Data Type</th><th width="202">Full-Import</th><th width="243">Delta-Import</th><th width="200">Description</th><th>Example</th></tr></thead><tbody><tr><td><code>store</code></td><td>Integer</td><td>Required</td><td>Required</td><td>Store identifier that represents a unique store in your source system.</td><td>501</td></tr><tr><td>ean</td><td>String</td><td>Required</td><td>Required</td><td>EAN of the article. Unique per store in the file, otherwise such articles are dropped and not handled.</td><td>0075678164125</td></tr><tr><td><code>quantity</code></td><td>Integer</td><td>Required</td><td>Required</td><td>Number of articles available at the store.</td><td>12</td></tr><tr><td><code>product_number</code></td><td>String</td><td>Required</td><td>Required</td><td>Unique product number that the client uses to identify a specific product.</td><td>88882572, 18751-060</td></tr><tr><td><code>price</code></td><td>Float</td><td>Required</td><td></td><td>Current selling price of an article, use dot . as a decimal separator, e.g: 10.54.</td><td>131.95</td></tr><tr><td><code>retail_price</code></td><td>Float</td><td>Required</td><td></td><td>Retail price of an article (RRP) is the original price of the article before applying any discount. Use dot . as a decimal separator, e.g: 10.54</td><td>329.95</td></tr><tr><td><code>brand</code></td><td>String</td><td>Required</td><td></td><td>Product brand</td><td>HUGO BOSS</td></tr><tr><td><code>product_group</code></td><td>String</td><td>Required</td><td></td><td>Product category</td><td>Jeans, T-Shirt</td></tr><tr><td><code>article_size</code></td><td>String</td><td>Required</td><td></td><td>Article size</td><td>S, 32</td></tr><tr><td><code>purchase_price</code></td><td>Float</td><td>Required</td><td></td><td>Purchase price </td><td>78.95</td></tr><tr><td><code>article_number</code></td><td>String</td><td>Recommended</td><td></td><td>Article number</td><td>18751</td></tr><tr><td><code>product_name</code></td><td>String</td><td></td><td></td><td>Product name, highly recommended field as this helps stores to identify the product.</td><td>Superstar Track Jacket, Converse Sneaker</td></tr><tr><td><code>article_color</code></td><td>String</td><td></td><td></td><td>Article color</td><td>White</td></tr><tr><td><code>article_color_number</code></td><td>Integer</td><td></td><td></td><td>Article color number</td><td>142</td></tr><tr><td><code>season</code></td><td>String</td><td></td><td></td><td>Article season, highly recommended field as this helps stores to control feed upload by season.</td><td>FS 2021</td></tr><tr><td><code>first_purchase_date</code></td><td>String</td><td></td><td></td><td>First purchase date, highly recommended field as this helps stores to control feed upload by first purchase date.</td><td>2022-07-01</td></tr><tr><td><code>store_article_location</code></td><td>String</td><td></td><td></td><td>The article location helps the store clerks to locate the article <strong>within</strong> the store.</td><td>3rd Floor, 201</td></tr><tr><td><code>picture</code></td><td>String</td><td></td><td></td><td>Default picture URL</td><td><a href="https://api.fashioncloud.co/v2/products/media/images/60b4d44328ebf50011dd3246?token=0c6da146dd36758385a428fac6b6b0c8&#x26;px=200&#x26;minAcceptableSize=200">https://api.fashioncloud.co/v2/products/media/images/60b4d44328ebf50011dd3246?token=0c6da146dd36758385a428fac6b6b0c8&#x26;px=200&#x26;minAcceptableSize=200</a></td></tr><tr><td><code>tag_1-n</code></td><td>String</td><td></td><td></td><td>Article tag, helps stores to control feed upload by tag value</td><td>Promotion, NO_DISCOUNT, SALE</td></tr><tr><td><code>gender</code></td><td>String</td><td></td><td></td><td>Gender</td><td>Allowed values:<br><code>male</code>, <code>female</code> and <code>unisex</code></td></tr><tr><td><code>age_group</code></td><td>String</td><td></td><td></td><td>Age group</td><td>Allowed values:<br><code>adults</code>, <code>teens</code>, <code>kids</code>, <code>babies</code>, <code>newborn</code> or <code>unknown</code></td></tr><tr><td><code>description</code></td><td>String</td><td></td><td></td><td>Product description</td><td>Denim Shorts in schöner Waschung. Elasthananteil für bequemen Sitz</td></tr><tr><td><code>picture_1-n</code></td><td>String</td><td></td><td></td><td>Additional picture URLs</td><td><a href="https://api.fashioncloud.co/v2/products/media/images/60b4d44328ebf50011dd3246?token=0c6da146dd36758385a428fac6b6b0c8&#x26;px=200&#x26;minAcceptableSize=200">https://api.fashioncloud.co/v2/products/media/images/60b4d44328ebf50011dd3246?token=0c6da146dd36758385a428fac6b6b0c8&#x26;px=200&#x26;minAcceptableSize=200</a></td></tr><tr><td><code>material</code></td><td>String</td><td></td><td></td><td>Product material composition</td><td>Obermaterial: 81% Baumwolle, 17% Polyester, 2% Elasthan</td></tr><tr><td><code>care_instructions</code></td><td>String</td><td></td><td></td><td>Product care instructions </td><td>Maschinenwäsche bei 30°C, Schonwaschgang, nicht Trockner geeignet</td></tr><tr><td><code>product_group_number</code></td><td>Integer</td><td></td><td></td><td>Product group number</td><td>23124</td></tr><tr><td><code>erp_inventory_item_id</code></td><td>String</td><td></td><td></td><td>Internal ERP inventory item id</td><td>45213620895960</td></tr><tr><td><code>erp_variant_id</code></td><td>String</td><td></td><td></td><td>Internal ERP variant id</td><td>43118558642392</td></tr><tr><td><code>erp_product_id</code></td><td>String</td><td></td><td></td><td>Internal ERP product id</td><td>7765899346136</td></tr><tr><td><code>company_id</code></td><td>String</td><td></td><td></td><td>Company id (group of stores) item belongs to</td><td>m1</td></tr></tbody></table>

Sample stock file

#### Full-Import&#x20;

```
store;ean;price;retail_price;quantity;product_number;product_name;article_number;article_color;article_size;store_article_location
100;5704498811166;99.95;99.95;10;"TOB21N00G";"Jeans Skinny Fit";"TOB21N00G-K11";"niceville mid";"24x30";"301"
101;4061749183108;169.95;199.95;2;"272762";"ZAIDA TURTLENECK - Strickpullover - nou...";"4060606039817";"Blue";"M";"1st floor"
```

**Delta-Import**

```
store;ean;quantity;product_number
100;5704498811166;10;"TOB21N00G"
101;4061749183108;2;"272762"
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://m-board.gitbook.io/docs/stock-upload-csv.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.