Project

General

Profile

Tasks #12491

UOM conversion Barcode details

Added by Rijas P about 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
Urgent
Assignee:
Rijas P
Start date:
11/27/2023
Due date:
% Done:

100%

Estimated time:
Spent time:
0.25 h

Description

Dear Ijas,

Please share CSV file of full items list with all Uom conversions and it's barcode. From export products, getting only 2 Uom conversions. In our case some items have 3 or 4 conversions.

Files

uom_conversions_list_12491.csv (589 KB) uom_conversions_list_12491.csv Mohamed Suhail, 11/27/2023 12:41 PM

History

#1

Updated by Mohamed Suhail about 1 year ago

Rijas P wrote:

Dear Ijas,

Please share CSV file of full items list with all Uom conversions and it's barcode. From export products, getting only 2 Uom conversions. In our case some items have 3 or 4 conversions.

PFA the csv file to see the details requested

Query used is


copy (select * from (
select mp.name productname,sku,cuc.upc,cu.name uom,cuc.dividerate from m_product mp join c_uom_conversion cuc on mp.m_product_id=cuc.m_product_id and mp.c_uom_id=cuc.c_uom_id and cuc.isactive='Y' join c_uom cu on cu.c_uom_id=cuc.c_uom_to_id where mp.ad_client_id=1000000 and mp.isactive='Y') as aa order by 1,5) to '/tmp/uom_conversions_list_12491.csv' with delimiter ',' csv header;

#2

Updated by Rijas P about 1 year ago

  • Status changed from Resolved to Closed

Dear Suhail,

Thanks for your prompt action.

#3

Updated by SHAIJAL EDAVANA 8 months ago

  • Tracker changed from Bug to Tasks
  • Project changed from Euro Novelties to Temp Projects
  • Category deleted (Others)

Also available in: Atom PDF