<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Inventory import]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5103&amp;type=atom" />
	<updated>2014-08-21T19:06:29Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=5103</id>
		<entry>
			<title type="html"><![CDATA[Re: Inventory import]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=20527#p20527" />
			<content type="html"><![CDATA[<p>Add 1 item.<br />Export it<br />study the exported file format.<br />Prepare the rest of the items in that format.<br />Now import the rest.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2014-08-21T19:06:29Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=20527#p20527</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Inventory import]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=20518#p20518" />
			<content type="html"><![CDATA[<p>Is there no way to import quantities as part of the Import CSV process?</p><p>I looked at the import_items.php file and mimicked the file layout in the section referring to the import items.</p><p>Here&#039;s the commented layout I used:</p><p>type, item_code, stock_id, description, category, units, qty, mb_flag, currency, price</p><p>However, when i go to import it I&#039;m getting a SQL every time. I&#039;ve double and triple checked it and the import columns are exactly the way they read above in the csv. </p><p>At first it belly ached about a problem with the 0_dimension table and I found a reference that suggested there was a typing error in one line (needed the double ==&nbsp; for the compare). I changed that and didn&#039;t get the error, but it did absolutely nothing but take me right back to the items import page. </p><p>I&#039;m a bit stumped as to how you&#039;re supposed to load skus with qtys and I can&#039;t even begin to entertain this if I have to write something to update them in sql. </p><p>Ideas?</p><p>Thanks,</p><p>C.</p>]]></content>
			<author>
				<name><![CDATA[cdubks88]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19563</uri>
			</author>
			<updated>2014-08-19T14:08:41Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=20518#p20518</id>
		</entry>
</feed>
