I would like to define income and expense accounts for a product during a csv-import. What I tried so far is to export keys "property_account_expense/id" and "property_account_income/id". They contain values like "product_product_721_1", "product_product_721_2" aso. So they seem not to reference an existing account directly. How can I reference an existing account, say "account_account_721"?
You seem to be doing the right thing. When you export the "Expense Account" and "Income Account" columns, you should not pay attention to the looks of the External ID of those accounts, it's correct, Technically it will look like
__export__.product_product_864 simply because it was generated on-the-fly while performing an export of product with ID 864. But it still refers to an account, so you can reuse it for another product if you want to use the same account.
Have you actually tried to copy that value (including the
__export__ prefix!) to another product and re-import that modified file? Does it work? It should work just fine.
Note that providing an External ID for filling in a column is only one of the possible options, albeit the safer one.
You can also change the title of the column and drop the
/id part (i.e.
property_account_income) and then provide the account name (ideally unique!) or preferably the account code in that column, instead of the External ID.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 9/7/13, 1:00 PM|
|Seen: 2846 times|
|Last updated: 3/16/15, 8:10 AM|