# Inventory Importer

**URL:** <https://forum.sambapos.com/t/inventory-importer/11893>\
**Category:** V5 Question\
**Created:** [July 31, 2016, 5:06am UTC](https://forum.sambapos.com/t/inventory-importer/11893 "2016-07-31T05:06:17Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ahmed](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/a/8c91f0/32.png) [@ahmed](https://forum.sambapos.com/u/ahmed)\
**Post date:** [July 31, 2016, 5:06am UTC](https://forum.sambapos.com/t/inventory-importer/11893/1 "2016-07-31T05:06:17Z")

</div>

> [@SambaPOS 5 Bulk Product and Inventory Importer](https://forum.sambapos.com/t/sambapos-5-bulk-product-and-inventory-importer/10809):
>
> ##Synopsis This Tool is primarily used as a Bulk Product, Inventory, and Recipe importer based on data read from a CSV file. This is especially useful in Retail applications where there is a direct 1:1 relationship between Items you buy from a supplier and Products you sell. As of this release, this Tool is compatible with the following SambaPOS versions: 5.1.58 - 5.1.60 (DB version 124) ::: [dbops124c.zip](https://forum.sambapos.com/uploads/default/original/3X/d/1/d15e79bb9e88db8c2941bcaaa7c471988b6b466c.zip) (24.6 KB) Originally developed by @JohnS for SambaPOS 3, updates to the Tool were dev…

I’ve used the importer but the problem is that CSV files change the barcode values so im unable to import the barcodes properly. Would it be possible to use .xlsx files instead?

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [July 31, 2016, 10:31am UTC](https://forum.sambapos.com/t/inventory-importer/11893/2 "2016-07-31T10:31:54Z")

</div>

No. XLS(X) files are a proprietary file format.

CSV files do not “change” barcodes. They are plain-text files. If you think they are being changed, that is because Excel is formatting and displaying them improperly. It might even be saving them improperly.

Open the CSV file in Notepad instead to see the “real” barcode and other content that the CSV file actually contains.

---

<div class="post-metadata">

**Author:** ![ahmed](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/a/8c91f0/32.png) [@ahmed](https://forum.sambapos.com/u/ahmed)\
**Post date:** [July 31, 2016, 3:40pm UTC](https://forum.sambapos.com/t/inventory-importer/11893/3 "2016-07-31T15:40:44Z")

</div>

![](https://forum.sambapos.com/uploads/default/original/3X/b/f/bf8c220b3f176470d7b04bf3bc2989983cd0ee9d.png)

The CSV file formats the bar code and it gets imported to SambaPOS in the CSV formatted style

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [July 31, 2016, 4:35pm UTC](https://forum.sambapos.com/t/inventory-importer/11893/4 "2016-07-31T16:35:33Z")

</div>

> [@ahmed](#):
>
> The CSV file formats the bar code

No, it does not. **Excel is doing that** , and when you save the file, _ **Excel** _ is writing formatted barcode data to the CSV file.

Open a “good” CSV file with Excel. Change the barcode column format to Custom, so that Excel does not display formatted data. Save the file as CSV.

---

<div class="post-metadata">

**Author:** ![ahmed](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/a/8c91f0/32.png) [@ahmed](https://forum.sambapos.com/u/ahmed)\
**Post date:** [July 31, 2016, 5:06pm UTC](https://forum.sambapos.com/t/inventory-importer/11893/5 "2016-07-31T17:06:54Z")

</div>

I[quote=“QMcKay, post:4, topic:11893”]  
No, it does not. Excel is doing that, and when you save the file, Excel is writing formatted barcode data to the CSV file.

Open a “good” CSV file with Excel. Change the barcode column format to Custom, so that Excel does not display formatted data. Save the file as CSV.  
[/quote]

I opened a “good” CSV file and changed the format to custom, but after saved the file it was reverted back to Excel’s formatted data. Would it help to use another software other than Excel?

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [July 31, 2016, 5:28pm UTC](https://forum.sambapos.com/t/inventory-importer/11893/6 "2016-07-31T17:28:27Z")

</div>

You can open it in notepad or you get set the format in excel so it works.

---

<div class="post-metadata">

**Author:** ![ahmed](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/a/8c91f0/32.png) [@ahmed](https://forum.sambapos.com/u/ahmed)\
**Post date:** [July 31, 2016, 5:30pm UTC](https://forum.sambapos.com/t/inventory-importer/11893/7 "2016-07-31T17:30:26Z")

</div>

I tried setting the format but the format gets reverted after saving the file in Excel.

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [July 31, 2016, 6:00pm UTC](https://forum.sambapos.com/t/inventory-importer/11893/8 "2016-07-31T18:00:27Z")

</div>

Set the column format to Text.
