Home› Brick Owl› Features

Manual for import inventory?

patpendlegopatpendlego
in Features Vote Up0Vote Down
Is there a manual (or extensive description) for import inventory functionality?
I.c. the fields, data types, etc?

Comments

  • 13 Comments sorted by Votes Date Added
  • Colorado BricksColorado Bricks
    Vote Up0Vote Down
    This is a good start: https://www.brickowl.com/api_docs
  • patpendlegopatpendlego
    Vote Up0Vote Down
    Thx. Although interesting material I have no way to use API at the moment. Just looking for a description of import file.
  • LawrenceLawrence
    Vote Up0Vote Down
    If you choose one of the brick owl import file types there’s a detailed explanation directly on the form
  • patpendlegopatpendlego
    Vote Up0Vote Down
    Okay, I'll figure it out somehow. Learning by doing :wink:
  • patpendlegopatpendlego
    Vote Up0Vote Down
    On import, how to specify the color of an item? I do not see a field-definition for it...
    Also, is there a list of colors (id, description) available?
  • patpendlegopatpendlego
    Vote Up0Vote Down
    Found this page:
    https://www.brickowl.com/colors

    Is it also available as download file? CSV, XML, Excel?
  • beaverbrickbeaverbrick
    edited March 2021 Vote Up0Vote Down
    The colours can be downloaded via the API, but I don't think there's any other download options available.
    You could select all the colours in that table and copy & paste them into Excel (although I've just realised that you don't get the BrickOwl colour ID when you do that).

    Regarding the upload, I'm honestly not sure. I don't think the info is very clear at all. I've tried playing around with uploading XML's but I get errors each time.
    The schema's really need to be visible for the import types with tag names etc. so we know exactly what format the file should be in.

    Just looking at a backup from my store, the colour gets attached to the end of the BOID e.g. 518532-38
  • patpendlegopatpendlego
    Vote Up0Vote Down
    This seems the one:
    GET https://api.brickowl.com/v1/catalog/color_list

    But I have no idea how to execute it.

    I am also looking at the backup download, it seems color names are included in the description so perhaps when uploading they should be too in the description as well.
    I am using BL colors in my backend software so I am thinking about a conversion table to obtain the BO colors, but for that it would be nice to have a color download.

    @Lawrence do you have a solution for this?
  • VosblokjesVosblokjes
    edited March 2021 Vote Up0Vote Down
    If you have a API key (see tab API keys in https://www.brickowl.com/user you can also get an API key there) you get it through your webbrowser:
    https://api.brickowl.com/v1/catalog/color_list?key=xxx
    where xxx is your key.
  • patpendlegopatpendlego
    edited March 2021 Vote Up0Vote Down
    @BasKrie Thx! That works. The output is json, and with a converter I get XML. Nice! It contains the BL color names so with that I can create a conversion table to BO colors.
  • beaverbrickbeaverbrick
    Vote Up0Vote Down
    Depends on your programming skills!
    Your program needs to be able to download that list of colours and then you need a JSON parser to actually make sense of it.
    If you know a bit of programming, you could probably do it fairly easily. I've got some VBA code in an Excel spreadsheet to do it.

    I wouldn't expect the colour to be part of the description on upload. Shouldn't even need a description at all as the BOID/Item ID will take care of that.
  • patpendlegopatpendlego
    edited March 2021 Vote Up0Vote Down
    Next issue... The XML contains an invalid looping element.
    <root>
    <0>
    <id>0</id>
    ...
    </0>
    <2>
    <id>2</id>

    The looping element is <0> <2> etc. where (I guess) it should be a fixed name like <color>.
    I am using PDI to read the XML but it cannot recognize elements.

    So, why is the repeating element numbered? Maybe that is how it works within API/json?
  • patpendlegopatpendlego
    Vote Up0Vote Down
    Duh! PDI can read json also. Trying that option now.
Sign In or Register to comment.