Import changes to existing inventory with a smaller selection of data (for example rate and weight)
First export product information (copy/paste the query below into Export Query Builder )
SELECT G.group_code AS [Product Group],
G.group_descv6 AS [Group Description],
IM.category AS [Product Category],
C.cat_descv6 AS [Category Description],
IM.product_code AS [Product Code],
IM.descriptionv6 AS [Product Description],
IM.printeddesc AS [Printed Description],
IM.unit_volume AS [Unit Volume],
IM.unit_weight AS [Unit Weight],
IM.rlength AS [Unit Length],
IM.rwidth AS [Unit Width],
IM.rheight AS [Unit Height],
IM.cost_price AS [Cost price],
R.rate_1st_day AS [Rate1st Day],
R.rate_extra_days AS [Rate Extra Days],
R.rate_week AS [Rate Week],
R.rate_long_term AS [Rate Long Term]
FROM dbo.tblinvmas AS IM
LEFT OUTER JOIN dbo.tblgroup AS G
ON G.group_code = IM.groupfld
LEFT OUTER JOIN dbo.tblcategory AS C
ON C.category_code = IM.category
LEFT OUTER JOIN dbo.tblratetbl AS R
ON R.productcode = IM.product_code
AND R.tableno = 0
WHERE ( IM.product_type_v41 = 0 )
ORDER BY [product group],
[product category],
[product code]
Then modify using the guidelines below:
- Do not change the Key values for each product (as outlined below).
- Modify the other details as needed.
- Do not use commas in any of the fields
- Then save as csv or tab delimited file.
There is no 'Undo Import' option, ensure you have a backup of your database before importing
- From the main menu Others-->Import/Export option from Rentalpoint main menu
