Overview
Stay organized with collections
Save and categorize content based on your preferences.
There are operational reports built and used on the Google side for WMS data
including the 3PL WMS systems for tracking different metrics and not
all data needed for the reporting is available through the transactional
API/EDI integrations between 3PL partner system and Google ERP system.
Hence this data pipelines are required to get the data from the 3PL WMS system
for reporting.
The following include technical specifications of the csv formatted files
3PL warehouse systems for reporting.
NOTE: The first row of the file must contain the column headers, which are the
names of the data elements and must be in the order shown in the corresponding
specification page. Optional columns are still required on header.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-08-16 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-08-16 UTC."],[[["Google uses operational reports built with WMS data, including 3PL systems, to track various metrics."],["Not all necessary reporting data is available through existing API/EDI integrations between Google's ERP system and 3PL partners."],["Dedicated data pipelines are needed to extract the required data from 3PL WMS systems for these reports."],["These pipelines deliver data in CSV format with the first row containing column headers in a specific order."],["Even optional columns need to be included in the header row of the CSV files."]]],["Operational reports on Google use data from 3PL WMS systems to track metrics. Not all necessary data is available via existing API/EDI integrations, necessitating data pipelines to extract data directly from the 3PL WMS systems. Reports rely on CSV files from these systems, requiring specific formatting: the first row must contain column headers in a prescribed order, including headers for optional columns. The file specifications define these data elements.\n"]]