Question about the right structure/setup

Get Help
1

Dear Community,

I am new to Fibery and I think I love it. :slight_smile:

So I am trying to setup a product management for a small fashion label and I would love to understand if I got it right.
I have something like that in Airtable at the moment, but I am not fully happy, so I love to do it in Fibery.

My current structure is:

  • Products
    • All products we want to manufacture and sell
  • Product Tasks
    • All tasks related to the product from ideation to prototype to production to go live
    • But maybe we can merge this with products?
  • Product Components
    • All product components
    • Can be linked to one supplier, but different products
  • Supplier
    • Can be linked to product components or products (e.g. manufacturer) or sourcing orders
  • Sourcing Orders
    • Can be linked to products and supplier
  • Sales Forecast
    • Can be linked to products and maybe marketing campaigns?
  • Sales Actual
    • Linked to Shopify?
    • Linked to products
  • Cost Forecast
    • Cost item
    • Some can be linked to Sourcing Orders
  • Marketing Campaigns
    • All campaigns for all channel incl. status, dates, duration, success, content
    • Kanban board
  • Marketing Channel
    • All Channels, like Insta, Pinterest, SEO, SEA
  • Marketing or content item
    • Items like Insta post, Pinterest post, SEO article, PR move, Linkedin post
    • Status and Kanban board
    • Can be linked to marketing campaigns
  • Operations
    • All tasks related to operation, setup infrastructure, new online shop features

Dashboards for e.g. Sales FC vs. Sales Actual vs. Cost, when to order something new.

Level 1 would be databases I guess?
Would that make sense?

I could also add an brand database, in case we want to manage two brands.
In this case we would add each item also to an brand from the brand database?
Would this be the right approach?

Many many thanks in advance! :slight_smile:

Kind Regards & happy weekend
Markus

2

Fibery is organized with Spaces and Databases. We usually advice to think of Space like a Process with several cohesive databases. I don’t know full context, but from what I see you might have something like this

Spaces / Databases

  • Product
    – Brands
    – Products
    – Product Tasks
    – Components
  • CRM
    – Suppliers
    – Orders
    – Sales (Forecast or Actual can be in one database I guess, not sure how you calculate forecasts)
    – Cost Forecast
  • Marketing
    – Campaigns
    – Channels
    – Content Items
  • Operations
    – Tasks

Note that you can move databases between Spaces easily in Fibery and has cross-space relations without any data-replication workaround as in Airtable.

Fibery has no Shopify integration out of the box.
Reports are quite powerful, so I think you will be able to visualize all you need having the data.

1 Like
3

Thank you very much Michael.
I see, that makes sense.

Let’s say I have 3 businesses.
2 different Online Shops and 1 service business.

Would it make sense to have a space projects/businesses and link every item also to a business?
Or would you have the spaces for each business separated?
Of course the products will be different and the lifecycle of the products and services will be different and so will the workflow/process states.

Additionally a dashboard view somewhere to collect all forecast and sales data and show it combined? Also maybe a roadmap view? :slight_smile:

Regarding the shopify integration, it could be done via Zapier? Push each sale to Fibery and link it with products. For that I would need a custom product id, which is also in Shopify.
On the other hand I could push it to BigQuery and do the reports in Looker Studio.
But would be nice to have it in Fibery.

Many thanks again in advance!

Kind Regards
Markus

4

It depends. If fields in products in difference businesses are VERY different, then it makes sense to create separate databases for every product and different spaces will also make sense.

If they are not so different, one Products database would be enough and a single Space. For example, maybe for Online Shops the are similar and you will have Online Shops space and another Space for Services.

Additionally a dashboard view somewhere to collect all forecast and sales data and show it combined? Also maybe a roadmap view? :slight_smile:

More details about how you want to have it (or have it now) would help, it is quite hard to advice without details here…

Regarding the shopify integration, it could be done via Zapier?

Yes, it will work.

1 Like
5

Thank you very much for your help! Will give it a try. :slight_smile: