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."],[[["\u003cp\u003eGoogle uses operational reports built with WMS data, including 3PL systems, to track various metrics.\u003c/p\u003e\n"],["\u003cp\u003eNot all necessary reporting data is available through existing API/EDI integrations between Google's ERP system and 3PL partners.\u003c/p\u003e\n"],["\u003cp\u003eDedicated data pipelines are needed to extract the required data from 3PL WMS systems for these reports.\u003c/p\u003e\n"],["\u003cp\u003eThese pipelines deliver data in CSV format with the first row containing column headers in a specific order.\u003c/p\u003e\n"],["\u003cp\u003eEven optional columns need to be included in the header row of the CSV files.\u003c/p\u003e\n"]]],["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"],null,["There are operational reports built and used on the Google side for WMS data\nincluding the 3PL WMS systems for tracking different metrics and not\nall data needed for the reporting is available through the transactional\nAPI/EDI integrations between 3PL partner system and Google ERP system.\nHence this data pipelines are required to get the data from the 3PL WMS system\nfor reporting.\n\nThe following include technical specifications of the csv formatted files\n3PL warehouse systems for reporting.\n\nNOTE: The first row of the file must contain the column headers, which are the\nnames of the data elements and must be in the order shown in the corresponding\nspecification page. Optional columns are still required on header."]]