> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.julesai.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# I Can Create Purchase and Sale with Bulk Material Upload via Excel or PDF

${frame}[I Can Create Purchase and Sale with Bulk Material Upload via Excel or PDF](https://julesai.clueso.io/embed/d89d5f74-470f-4101-b866-4b288a8cdba0)

This article will guide you through the process of adding more materials to an order via bulk upload.

**Step 1:** Begin by creating a new order.

![](https://usercontent.us.prod.clueso.io/0affecff-6113-4a1f-b1e4-103d4789d78a/d89d5f74-470f-4101-b866-4b288a8cdba0/cc986c24-9dbb-49fe-b5f2-ff69505f4cfb/images/f8f94783-b3fd-44d4-a244-9a18cab2fec8.png)

**Step 2:** Choose your supplier and fill in the necessary information. Instead of hitting **Next**, select the drop-down option and click on **Save and Bulk Upload** to add materials.

![](https://usercontent.us.prod.clueso.io/0affecff-6113-4a1f-b1e4-103d4789d78a/d89d5f74-470f-4101-b866-4b288a8cdba0/cc986c24-9dbb-49fe-b5f2-ff69505f4cfb/images/02af9ad3-a117-4a06-90bf-b233ef0a0c2a.png)

**Step 3:** At this point, you have the option to upload an Excel file or PDF containing all the material details.

![](https://usercontent.us.prod.clueso.io/0affecff-6113-4a1f-b1e4-103d4789d78a/d89d5f74-470f-4101-b866-4b288a8cdba0/cc986c24-9dbb-49fe-b5f2-ff69505f4cfb/images/bdfe728b-6a8c-438c-8962-15e697ee3a2d.png)

**Step 4:** Download the Excel template if needed. In this example, we've already prepared an Excel file. It includes the material name, document name, quantity, price, currency, incoderm, and all other required attributes.

![](https://usercontent.us.prod.clueso.io/0affecff-6113-4a1f-b1e4-103d4789d78a/d89d5f74-470f-4101-b866-4b288a8cdba0/cc986c24-9dbb-49fe-b5f2-ff69505f4cfb/images/f9d4a6fc-ccf2-43a8-ba2b-363ca9d4cad8.png)

**Step 5:** Upload the prepared Excel sheet. Select the tab you want to upload and match the columns. Skip any unnecessary columns, then click on **Confirm**.

![](https://usercontent.us.prod.clueso.io/0affecff-6113-4a1f-b1e4-103d4789d78a/d89d5f74-470f-4101-b866-4b288a8cdba0/cc986c24-9dbb-49fe-b5f2-ff69505f4cfb/images/3c56dcf6-396b-454f-ac6a-afbcf58565b5.png)

**Step 6:** Review all the details. You have the option to edit any necessary details, add a new row, or select and delete a row. Once you're satisfied with the data, click on **Complete Import** and **Submit**.

![](https://usercontent.us.prod.clueso.io/0affecff-6113-4a1f-b1e4-103d4789d78a/d89d5f74-470f-4101-b866-4b288a8cdba0/cc986c24-9dbb-49fe-b5f2-ff69505f4cfb/images/4f0f8a99-57ae-47fc-accf-8a9a281569d0.png)

**Step 7:** Now, all the commodities are included. You can view everything in list view, complete with all attributes.

![](https://usercontent.us.prod.clueso.io/0affecff-6113-4a1f-b1e4-103d4789d78a/d89d5f74-470f-4101-b866-4b288a8cdba0/cc986c24-9dbb-49fe-b5f2-ff69505f4cfb/images/a741676c-3542-4e49-a0eb-036c67b550d1.png)