Export Supplier Code without the need for Supplier Name
Mark Aldous
Hi Paul,
This can be achieved via the following method
- Goto Dashboards > Query Data
- Select the Query Type Product Suppliers
- Use the Supplier dropdown to select All Suppliers
- Click Generate Report
- Click Download (CSV file)
The report does indeed generate a report of items with the supplier and country code, however i am talking about the scheduled export data function. In the export inventory it allows you to add a supplier code however is asks for a supplier to be chosen, there is no option to select all suppliers. The Inventory supplier data export would be ok however this does not allow you to add additional columns such as bin rack or weight etc. Both exports functions are nearly there but just missing this ability.
I need a bit more customisation in the export which the query data all suppliers report doesn't allow.
Mark Aldous
Hi Paul,
to get the exact report you require this will require a custom script that can be then be used as a Automated Data Export.
This way you are able to state exactly which fields you need.
Other alternatives that can be achieved through the Automated Exports are as follows
Using the Export Type Inventory Supplier
In the Filter For Supplier Name add each supplier One by One to the Filter so that All Suppliers are listed
Tick the required columns such a Supplier Code
The export will include a row for each SKU that has one of your selected Supplier Names
The export does not include Bin Location
Using the Export Type Inventory with Additional columns
Use the Additional Columns option to Add Supplier Code
Give the column a name that is meaningful such as Ivan_SupCode where Ivan is the name of your Supplier
Select the Supplier Name from the drop down list
Repeat this process for each Supplier that you wish to include in the report
To include Bin Rack again use the Additional Column functionality to include it and select the Location you need to see the Bin Rack for
The export will include a single row for each SKU with the Supplier codes and Bin Racks pivoted up to columns
This is a much heavier export as every SKU is included in the report and also link to more tables to retrieve the required data.
So if you go down this route do not set up a 15 minute schedule for exports as you u will just be overloading your DB for no reason
regards
Mark
Many thanks for this info I will try the methods out you have suggested, I did not realise the option was there to schedule a customs script, however now I have seen it I may implement that also.
(p.s. I understand some of the feature requests may only be specific to my use)
Paul Kidd
The ability to export the supplier code in export data without having to specify the supplier name. If you have 10 different suppliers you cannot use one export sheet to get the information.
I use the exported data to run through our label printer software in which we need to display a supplier code of all products not just of one specified supplier.
Currently i have to use Bin Rack Field to contain supplier codes as this exports easily however due to expansion I will soon need to use the Bin Rack Field for its intended use.