Export Stock - Number in Export Stock got converted to Dates

Export Stock - Number in Export Stock got converted to Dates

How to Export Stock

You can export a stock from this screen.
{{IQURL}}/FactoryAdmin/ManageStock.aspx


Issue - Numbers in the column converted to Date

When you export a stock from IQ, and open it in Excel,
Sometime Excel convert the number into dates.
Unfortunately this is a well know Excel issue, and they have provided a work around to solve this issue.

Steps to prevent number into Date in Excel

1.  Open New Excel File.
2. Go to Data >> Get Data

3. Open the Drop down, select From File >> From Text/CSV

4. Select the CSV File you just exported.
Change the Data Type Detection to Do Not Detect Data Types.

Click Load.

Open Another Excel,
Select All
Copy

When Pasting, Select paste as Value,

The Code will be formatted as Text now


    • Related Articles

    • Creating and uploading stock spreadsheets CSV

        When you have got all the information back from the suppliers. It should be fully completed in the format as seen below.     As you can see all headings are highlighted and all fields are required (In this example they don’t have colour which is ok ...

    • SIMPLIFIED CSV - Option 4 - Flat Sheeting Pricing + Extras

        Flat Sheet Pricing plus extras – CSV pricing.   Using this method, you can upload ‘catalogue’ pricing into IQ using a combination of flat sheet pricing (base item ‘CSV’ uploads) and optional extras using job operations.   NOTE: This option is ...

    • Stock Bulk Upload

      We have created a PDF document that goes through the stock CSV import document in detail. It is the most up-to-date document. It is attached to this page. See this document for the most recent information on the CSV file, and a description of the ...

    • CHILI Document link via CSV Upload

      Link one or multiple CHILI Documents via CSV Upload Once you’ve completely designed your CHILI Document (or documents) and configured the variables, it’s time to link within printIQ so end users may order the product. A number of printIQ components ...

    • Stock - Inventory Component Pricing

      Overview We recommend using Inventory Based pricing as it is an update of the older 'Stock Size' based function. Stock based pricing is the original implementation of stock in printIQ but is now superseded by Inventory Based pricing. Inventory based ...